I use the following code
>>Sub TestA()
>>With Worksheets(1)
>>Set k = .Shapes.AddFormControl(xlListBox, 100, 10, 100, 100)
>> For x = 1 To 10
>> k.ControlFormat.AddItem "test" & x
>> Next
>>End With
>>End Sub
>>Sub TestB()
>>MsgBox "Hello"
>>End Sub
First run the procedure "TestA" which creates a drop dawn list (test1, test2, ...,test10) in work sheet(1).
After macro "TestB" assigned (Right click >Assign macro >TestB) to the drop down list.
Thus when i select an item from the drop down list i have the message "Hello"
I need help (the key words that i have to use) in order to add code that each time i select a item from the dropdown list, the value that i select (e.g "test2") to be returned with the MsgBox.
Many thanks
Bookmarks