listbox usage in vba

[Anusree]

Hi,
I have a sample VBA application, where in a dropdown gets populated dynamically.
hence I am not able to view the items in the dropdown completely.
Can you suggest & clarify a few doubts of mine regarding the same.
Q1. Usage of which component is better in the above scenario.i.e a listbox or a dropdown(ActiveX-control).
Q2. Assuming that usage of listbox is a good design option, How can i name a listbox?
Q3. What are the events that can be associated with the value change of the listbox.

Anticipating the favorable reply at the earliest.
Regards,
Anu

[royUK]

Why can't you view them? Widen the ComboBox or use a ListBox.

You can change the name in it's Properties & explore the ListBox's events in the VB Editor

[Paul]

Anusree,

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this.

Link to cross post: http://www.mrexcel.com/forum/showthr...99#post2476899