Object Req error putting combobox value into a cell

A

Andrew Kennerley

Joined
Oct 7, 2011
Messages
4
Reaction score
0
Hello

I inserted a combobox into a spreadsheet and want to copy the selection into a cell.

The following is in Module1:

Private Sub FrCharDropdown_Change()
Range("c4").Value = FrCharDropdown.Value
End Sub

FrCharDropdown.value generates an Object Req error.
I've tried to reference it in a number of ways but keep getting this error.

Can anyone tell me what I'm doing wrong.

Thanks
 
Andrew,

Is the combobox linked to a cell? If not, right click on it for the properties.

Stoneboysteve
 
Unfortunately it populates the cell with the item number rather than the value.

I'd like to be able to reference the other properties of the dropdown in vb as well - so this has to be the way.
 
Andrew,

Have you tried entering msgbox FrCharDropdown.Value as the first line in the subroutine to see if there is a value?

If the error is Object Req, can you try FrCharDropdown.Object.Value

Or can you attach your spreadsheet?

Stoneboysteve
 
Andrew,

Did you use the combobox control from 'forms' or the control toolbar? If you used it from forms, try replacing it with the combobox from the control toolbar.

Stoneboysteve
 
Back
Top