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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
get values from combobox in excel.
I assigned this macro to any/all of the dropdowns from the Forms toolbar and it
seemed to work ok: Option Explicit Sub testme() Dim myDD As DropDown Set myDD = ActiveSheet.DropDowns(Application.Caller) With myDD If .ListIndex 0 Then MsgBox .List(.ListIndex) End If End With End Sub roshinpp_77 wrote: Hi members, I am not able to get the values corresponding to selection made in combo box in excel sheet. In macro , i am not able to retrieve corresponding values of combo box 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 each selection. DropDown1.Value is not working!! pls help.. Roshin -- roshinpp_77 ------------------------------------------------------------------------ roshinpp_77's Profile: http://www.excelforum.com/member.php...o&userid=34924 View this thread: http://www.excelforum.com/showthread...hreadid=556381 -- Dave Peterson |
Reply |
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 |