General information
Category:
COM/DCOM and OLE Automation
Title:
Combobox value from MS Excel worksheet
hello,
i have a combobox named DropDown_5 placed on an excel worksheet. from this combobox i am displaying some values which i want a user to select from. On selecting a value from the combobox, i want to put the selected value in cell number C9 of my excel worksheet. I am unable to complete the command sequence below that would help me achieve my objective. Can someone please help me out.
With sincere thanks.
Sub DropDown5_Change()
Range("C9").Select
ActiveCell.FormulaR1C1 = .................
End Sub
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only