Connecting Tech Pros Worldwide Help | Site Map

How to put controls on a form with VBA code

BlueInGreen
Guest
 
Posts: n/a
#1: Nov 13 '05
How can I put a listbox, combobox... on a form, using VBA code?

Thx

polite person
Guest
 
Posts: n/a
#2: Nov 13 '05

re: How to put controls on a form with VBA code


On Wed, 07 Sep 2005 21:39:46 GMT, BlueInGreen <blueingreen@mail.com> wrote:
[color=blue]
>How can I put a listbox, combobox... on a form, using VBA code?
>
>Thx[/color]
Hi
With CreateControl function, which has to be used with the form in design mode.

As these controls have a lot of properties, and design mode is messy to use
at run time it will be lot easier to put the controls you may
need on the form in advance, invisible, and just set their properties and show
them when you want to "create" them.

Closed Thread