Combo Box (ActiveX)

  • Thread starter Thread starter Dovid
  • Start date Start date
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
 
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
 
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...
=---
 
Back
Top