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