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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform combobox question 20
ComboBox range lost 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
ComboBox Question 1
Add Item To ActiveX ComboBox 17
How to Display Arrow for Drop Down Lists in Message Body 0
Bring Data From MS Acess in a Combobox 1
DataSource for ComboBox in UserForm 3

Back
Top