Anyone know how to set the link cell on a combobox inside a userform? I was
expecting to see something in vba properties like 'linkedcell' (like you get
in the control toolbox combobox) but it's not there.

Many thanks

tp

Use the ControlSource property. If linking to cell C3 on a worksheet called
"DataSheet" just simply set the ControlSource property to:

DataSheet!C3

Note the exclamation mark

"teepee" wrote:

Anyone know how to set the link cell on a combobox inside a userform? I was
expecting to see something in vba properties like 'linkedcell' (like you get
in the control toolbox combobox) but it's not there.

Many thanks

tp

"Dom_Ciccone" wrote in message
...
Use the ControlSource property. If linking to cell C3 on a worksheet called
"DataSheet" just simply set the ControlSource property to:

DataSheet!C3

Many thanks Dom