Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Doug
Yes, add them to a custom Collection. Try this on a new userform containing Textbox1, Textbox2, Textbox3, Textbox4, ... Option Explicit 'top of userform module Dim MyControls As Collection Private Sub UserForm_Initialize() Set MyControls = New Collection MyControls.Add Me.TextBox1, "Txt1" MyControls.Add Me.TextBox2, "Txt2" MyControls.Add Me.TextBox3, "Txt3" End Sub Private Sub CommandButton1_Click() Dim ctl As MSForms.Control 'or .TextBox For Each ctl In MyControls ctl.Text = Now Next End Sub Private Sub UserForm_QueryClose(Cancel As Integer, _ CloseMode As Integer) Set MyControls = Nothing End Sub HTH. Best wishes Harald "Doug Glancy" skrev i melding ... Hello, Can I define an array of userform controls? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Grouping Userform Controls | Excel Programming | |||
Userform Controls | Excel Programming | |||
Help please with UserForm controls | Excel Programming | |||
UserForm Controls References | Excel Programming | |||
Add controls to UserForm | Excel Programming |