another combobox question

  • Thread starter Thread starter teepee
  • Start date Start date
T

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
 
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
 
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
 
Back
Top