Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validating data in a combobox
I would like to use data validation in a combobox.
I have a list of OEMs each of which may have multiple machines. Since this form will be used "in the field" I need the option of entering a new or previously unknown machine that is not yet in the list. Advice I received here led me to http://www.mcgimpsey.com/excel/lookuppics.html I was able to get this to work but it does not allow me to type in a new machine name. When I select a combobox and go to the Data tab the Validation button is "grayed out". How do I use the same data validation as the above URL in a combobox? I recieved this reply but Paul didn't address the "grayed out" Valadation button and didn't elaborate on the rest. you can use the datavalidation drop down list itself or a form or control combo.Just go to the source range or list and type your new machine there,all you will need to do is have a larger range than you actually have specified for the list... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Need step by step for entering data into combobox | Excel Discussion (Misc queries) | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Validating entry in ComboBox | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |