combo box text

[rwrede]

I figured out how to put text in a list in a "Forms"
combo box, but can't figure how to get a list of text in
an "ActiveX" combo box list. Also, how do I make that
text a link?

I would love it if there were a web site or tutorial that
showed samples of formulas and cool excel tricks and how
to do them?

 

[Bob Phillips]

ActiveX combos have a ListFillRange property that is used in the same way.
Select the combobox, go into the VBE (Alt-F11), select that worksheet, and
you should see the combobox in the properties window. Set the property
there. The value link property is LinkedCell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[rwrede]

I tried what I think you suggested to no avail. I am new
to this, I typed in ... LinkedCell=$A$1:$A$4 ... save
then tried it...

 

[Bob Phillips]

What happens?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[rwrede]

Nothing happens I get a blank pull down. I don't know
where or how to write the formula. I went to the VBE, and
I see the properties box and see...

Private Sub ComboBox1_Change()

End Sub


Where do I write the code and how? I wrote it between the
two lines (before 'End Sub')
should it be... =LinkedCell$A$1:$A$4 ?

 

[Bob Phillips]

The combobox is populated via the ListFillRange property. You don't need
code, you need to set it in the properties box.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

I got it! I was confused by the properties box in VBE. I
can acomplish the same thing by clicking the Properties
button on the 'Control Toolbox' on the worksheet and not
even open VBE. I entered A1:A5, my list appeared. Thanks.