Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adiing textbox..at runtime
hi there
i want to add the textboxes on my form at runtime equal to the number ..say two as per the input is it possible? -- hemu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adiing textbox..at runtime
Private Sub UserForm_Initialize()
Dim newCtrl As Control, num As Integer num = 2 For i = 1 To num Set newCtrl = _ Me.Controls.Add("Forms.TextBox.1", _ "txtBox" & i, True) newCtrl.Top = 30 * i Next i End Sub Hemant_india wrote: hi there i want to add the textboxes on my form at runtime equal to the number ..say two as per the input is it possible? -- hemu |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
adiing textbox..at runtime
million thanks JW
-- hemu "JW" wrote: Private Sub UserForm_Initialize() Dim newCtrl As Control, num As Integer num = 2 For i = 1 To num Set newCtrl = _ Me.Controls.Add("Forms.TextBox.1", _ "txtBox" & i, True) newCtrl.Top = 30 * i Next i End Sub Hemant_india wrote: hi there i want to add the textboxes on my form at runtime equal to the number ..say two as per the input is it possible? -- hemu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
How to create new textboxes during runtime?When user clicks on a button textbox shouls appear. | Excel Programming | |||
Runtime error textbox problem - help required | Excel Programming | |||
Deleting a textbox control at runtime | Excel Programming |