Create combo box in Excel using VB editor during run time

[Alvin]

How to create combo box in Excel during run time using VB editor?
would appreciate if someone can help me. thanks

 

[Tom Ogilvy]

Look in John Walkenbach's tip section on working with userforms. There are
several examples there - some on using the designer object with code and
some on just adding controls.

http://j-walk.com/ss/excel/tips/userformtips.htm