| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Box Drop-Down List
I have an input box for the user to enter a piece of data,
which is assigned to a particular variable, and in turn entered into a particular cell. The data input into the box, however, must be one of only a certain list of values. Am I able to create a drop-down list within the InputBox in order for only these particular values to be allowed to be input? Many thanks in advance, Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input Box Drop-Down List
No, you would need to create a userform with a combobox to get that
functionality. -- Regards, Tom Ogilvy "Chris Morgan" wrote in message ... I have an input box for the user to enter a piece of data, which is assigned to a particular variable, and in turn entered into a particular cell. The data input into the box, however, must be one of only a certain list of values. Am I able to create a drop-down list within the InputBox in order for only these particular values to be allowed to be input? Many thanks in advance, Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
| Need to make a drop down list of 3 items that input a value in ano | New Users to Excel | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| input range in drop down list | Excel Discussion (Misc queries) | |||
Linear Mode
