Combo Box?

[hce]

Hi All

Can someone KINDLY REFRESH MY oOLD BRAIN COS my memory is failing me..
Can someone kindly help to teach me how i can put the items into a comb
box on the userform...?

cheer

 

[JulieD]

Hi

normally against the form initialize event

combobox1.additem "item1"
combobox1.additem "item2"

or if coming from a range

Dim rng As Range

set rng = Range("A1:A10")

for each cell in rng
combobox1.additem cell.value
next

Cheers
JulieD

 

[Bob Phillips]

or link it to a worksheet range

ComboBox1.RowSource = "A1:A10"

--

HTH

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

Hi

normally against the form initialize event

combobox1.additem "item1"
combobox1.additem "item2"

or if coming from a range

Dim rng As Range

set rng = Range("A1:A10")

for each cell in rng
combobox1.additem cell.value
next

Cheers
JulieD

 

[JulieD]

i always forget that one

or link it to a worksheet range

ComboBox1.RowSource = "A1:A10"

--

HTH

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