how can I refrence cell's to combo box in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want use cocbo box but i don't know how can refrence cell's to this.The
don't have compelet information about this.
tahnk
 
Hi!

Using the Combobox from the Forms toolbar:
Combobox located in a worksheet; rightclick the combobox and select "Format
control", then you can set the Input range and cell links in the Control
tab.
Combobox in a Userform; read http://support.microsoft.com/?id=161598 for
details.

If the Combobox is from the Control Toolbox, then you have to use VBA
(doubleclick on the combobox in Design mode, and you will open Visual Basic
Editor.


Best regards

Stefan Hägglund
Microsoft
 
Hello
To reference cells to a combobox from the controls tool bar right-click on
the object and choose Properties
The Linked cell and ListFillRange are the properties you're after.
HTH
Regards
Pascal
 
You must log in or register to reply here.

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

how to carry forward a total from one page to another 3
Clicking on 1 cell to highlight other cells 1
Copy formula 2
cell refrence based on specific criteria 3
Links to other documents 2
Excel 2002: How to get the first and last reference in a column ? 7
Excel 2002: changing link formula from absolute to relative 3
copy increment by 1 6

Back
Top