How to obtain the selected value from a combo box in Excel?

[ultra2]

How to obtain the selected value from a combo box in Excel?
I have a combo box on an excel worksheet, how to write a makro (event handler) to change a cell value as a user choose a number from the combo?

Sub combo_change()
Cells(1, 10) = combo_value??
End Sub

plz help

 

[HarleyQuinn]

Try:

Cells(1, 10) = combo1.value

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[ultra2]

Cells(1, 10) = combo1.value
error: object required

 

[HarleyQuinn]

Is your combobox called combo1???

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[johnwm]

The default name for a combobox control in Excel is ComboBox1.

Private Sub ComboBox1_Change()
Range("a10") = ComboBox1.Value
End Sub

In future please note you do better with VBA questions in the VBA forum, that's forum707

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller