Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a UserForm with dozens of textboxes on it. I periodically need to
change the formatting of the textboxes and I been trying to write a macro to do it to no avail. Here' what I thought would work but it doesn't. HELP PLEASE. THANKS Sub ChangeFonts_Click() Dim Boxes As Long With editForm For Boxes = 1 To 78 ("TextBox" & Boxes).font .Name = "Arial" .FontStyle = "Bold" .Size = 10 Next End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
userform: object required | Excel Programming | |||
Drawing Object in a Userform | Excel Programming | |||
shape object on a userform? | Excel Programming | |||
Object on userform can't get focus | Excel Programming | |||
Using Userform object in Excel via automation from VB 6 | Excel Programming |