another combobox question
 

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

another combobox question
 

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

another combobox question
 

"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