Passing a value from a combo box to a cell on another sheet

[rahraw]

I am an amateur, so I tried the following to pass the value from a combobox named Dropdown2 to a sheet named GraphData, and got a "run-time error 424...object required" error message. Any ideas...thanks in advance!

Sub GetDealName()
Sheets("Sheet7").Range("A1").Value = Dropdown2.Value
End Sub

[Tinbendr]

Welcome to the board!

Please use code tags when posting code.

to a sheet named GraphData

Please Login or Register  to view this content.

[JLGWhiz]

Adding to Tinbendr's suggestion, if your Dropdown2 is on a different sheet than "GraphData", you should qualify Dropdown2 with that sheet reference. example:

Please Login or Register  to view this content.