Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get values from combobox in excel.
Hi members, I am not able to get the values corresponding to selection made i combo box in excel sheet. In macro , i am not able to retrieve corresponding values of combo bo selection. for eg: Sub DropDown1_Click() Select Case DropDown1.Value Case 0 'Left Top MsgBox "Left Top" Case 1 'Left Center MsgBox "Left Center" Case 2 'Left Bottom MsgBox "Left Bottom" Case 3 'Right Top MsgBox "Right Top" End Select End Sub Here my doubt is how to identify the name of the combobox in excel. After identifying the mname , how to retrieve values of eac selection. DropDown1.Value is not working!! pls help.. Roshi -- roshinpp_7 ----------------------------------------------------------------------- roshinpp_77's Profile: http://www.excelforum.com/member.php...fo&userid=3492 View this thread: http://www.excelforum.com/showthread.php?threadid=55638 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combobox values | Excel Programming | |||
Two values in a combobox | Excel Programming | |||
Combobox - use values in excel formula | Excel Worksheet Functions | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming | |||
Excel/VBA - Synchronize combobox values | Excel Programming |