Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use validation formulas in Combobox
What I want to do is for when the user selects a cell, a combo box based on
the field name pops up for better viewing and autocomplete, after a couple of keystrokes the selection is complete and a {Tab} or {Enter} key will populate the cell and it will be validated and move to the next cell. I have the data validation and movement working OK but the ComboBox is driving me batty. The data validation formula is ="=INDIRECT(VLookup(" & Place & ", lookup1, 2))" Where place is the Field title. This works in Data validation, but when I try to place in a combobox, I continue to get the formula in text form and not the value (name of the validation list) that I need. Anyone have sugestions? -- Glen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use validation formulas in Combobox
Worked out how to get the list right in the Combobox.
stg = Target.Validation.Formula1 stg = Right(stg, Len(stg) - 1) stg = Mid(stg, 10, Len(stg) - 10) stg = Evaluate(stg) Then used stg as the .ListFillRange Still want to exit the combo box with a keystroke. -- Glen "GlenC" wrote: What I want to do is for when the user selects a cell, a combo box based on the field name pops up for better viewing and autocomplete, after a couple of keystrokes the selection is complete and a {Tab} or {Enter} key will populate the cell and it will be validated and move to the next cell. I have the data validation and movement working OK but the ComboBox is driving me batty. The data validation formula is ="=INDIRECT(VLookup(" & Place & ", lookup1, 2))" Where place is the Field title. This works in Data validation, but when I try to place in a combobox, I continue to get the formula in text form and not the value (name of the validation list) that I need. Anyone have sugestions? -- Glen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
formulas for transferring data validation information in excel 200 | Excel Worksheet Functions |