MrExcel Publishing
Your One Stop for Excel Tips & Solutions

List Box using VBA


Posted by Kris on January 09, 2002 9:00 PM

Using VBA, how can I change the value in the listbox to a valid member in the list.

In other words, at one point in my VBA script, I always want the value of my list box to be a certain member of the list. For instance, if my list contains, "Jan","Feb","Mar", before I continue processing, i need to change the value to "Jan".

Thanks for your help.


Posted by Gil on January 09, 2002 9:18 PM


If i understand you correctly you want to put for example the "Jan" value to a constant, double click on the list box and then at the "listbox_change" or "click" function type the name of your constant, for example: MyMonth=listbox1.text and then continue with the code...

Gil.