Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pull down list + value checking
How do you create a pull down list in Excel? I would like to offer, say, 5
options in a pull down list and force the user to select a single one. Other times, users simply enter a value into one or more cells. A Command Button then takes them to the next page. Before doing so, I need Excel to check to see if a selection has been made (in the case of the pull down list) or if values have been entered into the appropriate cells. Using the Data Validation option for the cells does not ensure that 1.) a value has been entered, or 2.) the user has exited the cell--in which case the Command Button will not work. This must be simple but I'm yet to find it. Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pull down list + value checking
Check out http://www.contextures.com/xlDataVal01.html
-- HTH RP (remove nothere from the email address if mailing direct) "KimR.Hammel" wrote in message ... How do you create a pull down list in Excel? I would like to offer, say, 5 options in a pull down list and force the user to select a single one. Other times, users simply enter a value into one or more cells. A Command Button then takes them to the next page. Before doing so, I need Excel to check to see if a selection has been made (in the case of the pull down list) or if values have been entered into the appropriate cells. Using the Data Validation option for the cells does not ensure that 1.) a value has been entered, or 2.) the user has exited the cell--in which case the Command Button will not work. This must be simple but I'm yet to find it. Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pull down list + value checking
I'm not seeing it. I'm looking for the same thing. If the user didn't select
a value don't let the user continue. Could you be a little more specific where i can find this info on your page. Thanks! "Bob Phillips" wrote in message ... Check out http://www.contextures.com/xlDataVal01.html -- HTH RP (remove nothere from the email address if mailing direct) "KimR.Hammel" wrote in message ... How do you create a pull down list in Excel? I would like to offer, say, 5 options in a pull down list and force the user to select a single one. Other times, users simply enter a value into one or more cells. A Command Button then takes them to the next page. Before doing so, I need Excel to check to see if a selection has been made (in the case of the pull down list) or if values have been entered into the appropriate cells. Using the Data Validation option for the cells does not ensure that 1.) a value has been entered, or 2.) the user has exited the cell--in which case the Command Button will not work. This must be simple but I'm yet to find it. Thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
pull down list + value checking
This page will show you how to build the Data Validation list.
You then need to build some code to do any other processing. What do you mean exactly by not continue? -- HTH RP (remove nothere from the email address if mailing direct) "Heath Higgins" wrote in message ... I'm not seeing it. I'm looking for the same thing. If the user didn't select a value don't let the user continue. Could you be a little more specific where i can find this info on your page. Thanks! "Bob Phillips" wrote in message ... Check out http://www.contextures.com/xlDataVal01.html -- HTH RP (remove nothere from the email address if mailing direct) "KimR.Hammel" wrote in message ... How do you create a pull down list in Excel? I would like to offer, say, 5 options in a pull down list and force the user to select a single one. Other times, users simply enter a value into one or more cells. A Command Button then takes them to the next page. Before doing so, I need Excel to check to see if a selection has been made (in the case of the pull down list) or if values have been entered into the appropriate cells. Using the Data Validation option for the cells does not ensure that 1.) a value has been entered, or 2.) the user has exited the cell--in which case the Command Button will not work. This must be simple but I'm yet to find it. Thanks in advance |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
pull down list + value checking
The Command button should validate that there are values in the appropriate
cells prior to navigating to the next sheet. If you do it this way you can use the built in list function of the Data - Validation You need code similar to this in the command button if sheets("Sheet1").range("A1").value = "" then msgbox "Please Select a Value" sheets("Sheet1").range("A1").select else sheets("Sheet2").range("A1").select end if HTH "KimR.Hammel" wrote: How do you create a pull down list in Excel? I would like to offer, say, 5 options in a pull down list and force the user to select a single one. Other times, users simply enter a value into one or more cells. A Command Button then takes them to the next page. Before doing so, I need Excel to check to see if a selection has been made (in the case of the pull down list) or if values have been entered into the appropriate cells. Using the Data Validation option for the cells does not ensure that 1.) a value has been entered, or 2.) the user has exited the cell--in which case the Command Button will not work. This must be simple but I'm yet to find it. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull-down List | Excel Discussion (Misc queries) | |||
Checking whether a value in a list is present in a second list | Excel Discussion (Misc queries) | |||
checking for a value in a list | Excel Discussion (Misc queries) | |||
Checking if value is in a list | Excel Worksheet Functions | |||
Checking the last character is in a list | Excel Programming |