Object Req error putting combobox value into a cell

[Andrew Kennerley]

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

 

[Stoneboysteve]

Andrew,

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

Stoneboysteve

 

[Andrew Kennerley]

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.

 

[Stoneboysteve]

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 Kennerley]

Hi

Yes I've tried - and get the same message.

Also get the message for FrCharDropdown.Object.Value.

AK

 

[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

 

[Andrew Kennerley]

Thanks - that fixed it!