create dynamic comboboxes

M

Martin

Hello,

is it possible to create dynamic combo boxes?

I have an userform which saves the file into a specified folder. The user
can choose one out of 4 predefined folders from a combobox. I want to add a
button "Add folder", by what the user can enter the path and the folder would
appear in the comobbox.

The users are not proficient to fill the combobox via VBA and I want them to
be able to add folders without proggramming.

thank you

Martin
 
P

Patrick Molloy

if you have a text box above the listbox, and a button next to at , your
user can tyep the address in the textbox then click the button
the button's click event should be

listbox1.AddItem Textbox1.text
' these next two are optional
textbox1.text=""
listbox1.listindex = listbox1.listcount-1
'
this clears the textbox and highlights the last row of the listbox. this
though is akin to clicking the list box ...so don't use this if you're
trapping the listbox click event
 
Top