Combo Box (ActiveX)
 

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

--
Message posted from http://www.ExcelForum.com

Combo Box (ActiveX)
 

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



"Dovid " wrote in message
...
I'm attempting to create a combo box that by clicking on an entry in the
list, will populate a sheet according to data corresponding to that
entry.
Please give samples.
Thanks,
Dovid


---
Message posted from http://www.ExcelForum.com/





----== 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 =---

Combo Box (ActiveX)
 

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" wrote in message
...
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



"Dovid " wrote in message
...
I'm attempting to create a combo box that by clicking on an entry in the
list, will populate a sheet according to data corresponding to that
entry.
Please give samples.
Thanks,
Dovid


---
Message posted from http://www.ExcelForum.com/





----== 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
=---