this is better done with a listbox which is pretty easy to do in VBA on a
userform. You can have the list box or form hidden until it is needed,
doesn't have to be LIVE.

"Ray" wrote:

can any one tell me how you can add a drop down menu live in VB
to an Excel user Form.

it does look there is any way.

thanks

--
Ray