View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default ADD LISTBOX, COMBOBOX, LABEL IN THE SAME USERFORM

I've always found it much, much easier to add the controls in design mode. Then
use code to toggle the visibility. (You could change the position if you needed
to.)

Eddie_SP wrote:

In a multipage control, after clicking on a button, can I add a Listbox (or
any other object) without closing this multipage?

Example:

If Me.CommandButton1.Value = True Then
Listbox.Add
With Listbox
Width = X
Height = Y
Top = YY
Left = RR
End With

So... Is that possible?


--

Dave Peterson