 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / December 2005conditional data validation
I'm trying to create a conditional data validation for a cell ($D4) based on the entry in cell ($B4). There are three possible entries for cell $B4. I've created a named list for $B4 and based on the entry I want three different conditional data validation types for cell $D4: 1. Allow a range of numbers (1 to 255) 2. Drop-down list A 3. Drop-down list B I'm fairly proficient with Excel; however, I'm a very novice VBA programmer. Do you have any suggestions on the above situation? Rick Rick, Try this formula in the List Allow type in DV =IF(B4=1,ROW(1:255),IF(B4=2,listA,listB)) assuming that the two lists are named, else use the range references.  SignatureHTH Bob Phillips (remove nothere from email address if mailing direct) > I'm trying to create a conditional data validation for a cell ($D4) based on > the entry in cell ($B4). There are three possible entries for cell $B4. [quoted text clipped - 10 lines] > > Rick Bob, I tried your suggest and it does the provide the correct data validation; however, I was hoping that cell $D4 would actually display the appropriate drop-down list for user to choose from. I believe I can combine your suggestion with a procedure for using Dynamic lists that I found out on the Contextures web site. Thank you for your help. RickS > Rick, > [quoted text clipped - 20 lines] > > > > Rick Rick, In my tests listA and listB will shows as DD, it is only the 1-255 that doesn't. Isn't that what happens with you, or am I misunderstanding what you want? SignatureHTH Bob Phillips (remove nothere from email address if mailing direct) > Bob, > [quoted text clipped - 30 lines] > > > > > > Rick Bob, My DDs are not showing. I knew the 1-255 wouldn't show; however, I was going to handle this via the validation input message. You do understand what I'm trying to do, I'm just having problems with the execution. I'm going to play wiht this some more and I'll let you know how I make out. Thanks. Rick > Rick, > [quoted text clipped - 39 lines] > > > > > > > > Rick Rick, I have posted a simple example at http://cjoint.com/?mqoiKusXdS SignatureHTH Bob Phillips (remove nothere from email address if mailing direct) > Bob, > [quoted text clipped - 49 lines] > > > > > > > > > > Rick Bob, Just determined what I was doing wrong. Your suggestion works great. Thanks for the help. Rick > Bob, > [quoted text clipped - 49 lines] > > > > > > > > > > Rick |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.