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

M

M.J.Habibian

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
 
S

Stefan Hägglund [MSFT]

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
 
P

papou

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
 
Top