| 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 | |||
![Hemant_india[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
