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