Combo Box (ActiveX)

D

Dovid

I'm attempting to create a combo box that by clicking on an entry in th
list, will populate a sheet according to data corresponding to tha
entry.
Please give samples.
Thanks,
Dovi
 
B

Bob Phillips

He might also mean

Worksheets(1).Range("A1").Value = Combobox1.Value

to put the selected value on the worksheet.

--

HTH

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

Nigel said:
Use the row source property to link the values on the control to the
worksheet and the controlsource to define the destination.

Eg.......

Private Sub UserForm_Initialize()
UserForm1.ListBox1.RowSource = "A1:A5"
UserForm1.ListBox1.ControlSource = "B1"
End Sub.

Cheers
Nigel








----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
Click to expand...
=---
 
Top