Hi Vincent It seems more like sharing information - and we dnt find any other way to do this at runtime. If you've plz share with us.
Regards Ashish Jain On Apr 2, 6:09 pm, Yu <vincent2...@gmail.com> wrote: > Hi Dear all, > > I have this puzzle for a long time. I often program UserForm and > always format controls like this : > > .TextBox1.Height = 18 > .TextBox1.Width = 100 > .TextBox2.Height = 18 > .TextBox2.Width = 100 > .TextBox3.Height = 18 > .TextBox3.Width = 100 > .TextBox4.Height = 18 > .TextBox4.Width = 100 > .TextBox5.Height = 18 > .TextBox5.Width = 100 > > I am thinking is there a collection like TextBoxes ,then you can > refer to each textbox as TextBox(i) then just do > loop like this: > > For Each tb in TextBoxes > tb.height=18 > tb.width=100 > next tb > > Any ideas or any other way around that? > > Vincent --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
