another combobox question

[teepee]

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

 

[Guest]

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]

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