Posted to microsoft.public.excel.programming

Jennifer

external usenet poster

Posts: 385

Gotta be some more Efficient code

I have 10 text boxes is there a more efficient way to write this code.
Eventually there could be more textboxes and labels. Loop? Thank you so much.

If Len(Trim(Label1.Caption)) 0 Then
TextBox1.Visible = True
Else
TextBox1.Visible = False
End If
If Len(Trim(Label2.Caption)) 0 Then
TextBox2.Visible = True
Else
TextBox2.Visible = False
End If
--
Thank you,

Jennifer

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
More efficient code	Bob	Excel Programming	3	June 7th 07 09:44 PM
Can anyone help me convert to more efficient code?	slo	Excel Programming	2	August 4th 06 05:01 PM
Efficient Code	GregR	Excel Programming	7	June 27th 05 04:09 PM
More Efficient code than this	thom hoyle	Excel Programming	14	May 11th 05 07:40 AM
More efficient code	Rob Bovey	Excel Programming	1	July 9th 03 04:46 AM

All times are GMT +1. The time now is 03:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us