Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control on Sheet - Drop Down 1
Hello,
I have named range linked to a drop down in a sheet. Am having trouble finding the correct syntax to pull the string selected from the drop down€¦ Once I have that I am good to go. Thanks, Arturo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control on Sheet - Drop Down 1
What kind of dropdown
Data=Validation res = Range("B9").Value if the validation is applied to B9 Control Toolbox Toolbar res = Activesheet.Combobox1.Value Dropdown from the Forms Toolbar With Activesheet.DropDowns("Drop Down 1") res = .List(.Listindex) End With msgbox res -- Regards, Tom Ogilvy "Arturo" wrote in message ... Hello, I have named range linked to a drop down in a sheet. Am having trouble finding the correct syntax to pull the string selected from the drop down. Once I have that I am good to go. Thanks, Arturo |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control on Sheet - Drop Down 1
Dropdown from the Forms Toolbar ...
Should have been more specifc. Thanks! "Tom Ogilvy" wrote: What kind of dropdown Data=Validation res = Range("B9").Value if the validation is applied to B9 Control Toolbox Toolbar res = Activesheet.Combobox1.Value Dropdown from the Forms Toolbar With Activesheet.DropDowns("Drop Down 1") res = .List(.Listindex) End With msgbox res -- Regards, Tom Ogilvy "Arturo" wrote in message ... Hello, I have named range linked to a drop down in a sheet. Am having trouble finding the correct syntax to pull the string selected from the drop down. Once I have that I am good to go. Thanks, Arturo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a drop down control to choose a data series | Charts and Charting in Excel | |||
How to control drop down list width | Excel Worksheet Functions | |||
Cannot enter control for drop down box | Excel Worksheet Functions | |||
Drop Down Form control always causes excel to crash | Excel Discussion (Misc queries) | |||
Control Display of Drop Down List in Validation | Excel Worksheet Functions |