Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADD LISTBOX, COMBOBOX, LABEL IN THE SAME USERFORM
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADD LISTBOX, COMBOBOX, LABEL IN THE SAME USERFORM
must confess never added a control on the fly before but had a quick play &
managed to get following to work. Maybe give you some ideas to develop further. Private Sub CommandButton1_Click() Dim MyPage As MSforms.Page Dim MyListBox As MSforms.ListBox Set MyPage = MultiPage1.Pages(0) Set MyListBox = MyPage.Controls.Add("Forms.ListBox.1") With MyListBox .Top = 10 .Left = 20 .Height = 50 End With End Sub -- jb "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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADD LISTBOX, COMBOBOX, LABEL IN THE SAME USERFORM
Wow John, it started working...
I can go on from here now ! Thank you sir ! =) Thank you Dave. "john" wrote: must confess never added a control on the fly before but had a quick play & managed to get following to work. Maybe give you some ideas to develop further. Private Sub CommandButton1_Click() Dim MyPage As MSforms.Page Dim MyListBox As MSforms.ListBox Set MyPage = MultiPage1.Pages(0) Set MyListBox = MyPage.Controls.Add("Forms.ListBox.1") With MyListBox .Top = 10 .Left = 20 .Height = 50 End With End Sub -- jb "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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADD LISTBOX, COMBOBOX, LABEL IN THE SAME USERFORM
you are welcome.
if you want to add the control to a new page just replace this line: Set MyPage = MultiPage1.Pages(0) with this Set MyPage = MultiPage1.Pages.Add("Page" & MultiPage1.Pages.count + 1) good luck. -- jb "Eddie_SP" wrote: Wow John, it started working... I can go on from here now ! Thank you sir ! =) Thank you Dave. "john" wrote: must confess never added a control on the fly before but had a quick play & managed to get following to work. Maybe give you some ideas to develop further. Private Sub CommandButton1_Click() Dim MyPage As MSforms.Page Dim MyListBox As MSforms.ListBox Set MyPage = MultiPage1.Pages(0) Set MyListBox = MyPage.Controls.Add("Forms.ListBox.1") With MyListBox .Top = 10 .Left = 20 .Height = 50 End With End Sub -- jb "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill userform textbox from userform listbox clik event | Excel Programming | |||
View Listbox items in the Label | Excel Programming | |||
label on top of a listbox | Excel Programming | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
comboBox vs Listbox | Excel Programming |