Thread: How to enter a Range of TextBoxes?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bg18461 bg18461 is offline
external usenet poster
  
Posts: 1
Default How to enter a Range of TextBoxes?
Here is my redundant code,

TextBox1.Visible = False
TextBox2.Visible = False
TextBox3.Visible = False
TextBox4.Visible = False
TextBox5.Visible = False
TextBox6.Visible = False
TextBox7.Visible = False
TextBox8.Visible = False
TextBox9.Visible = False
TextBox10.Visible = False
TextBox11.Visible = False
TextBox12.Visible = False

Is there a easier way to enter a range of textboxes lik
(Textbox1:Textbox12).Visible = False. (This did not work).

P.S. - The textboxes are from the Control ToolBox

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote