| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid multiple select constructs
Hi,
I m a newbie, I have this select case checking for textbox values. I want to loop this so that it checks for all the textboxes. Or else I got to write the same code for each Textbox :( Select Case Me.TextBox1.Value Case Is < 2 Me.TextBox1.BackColor = &H80FF80 Case 2 To 4 Me.TextBox1.BackColor = &H80FFFF Case Is 4 Me.TextBox1.BackColor = &HFF End Select |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How 2 avoid multiple IF's by LOOKUP's??? | Excel Discussion (Misc queries) | |||
| How to avoid multiple IF's by LOOKUP's? | Excel Discussion (Misc queries) | |||
| Asking for better logic to avoid multiple if's. | Excel Programming | |||
| avoid multiple text in range | Excel Programming | |||
| If Select is the solution - how to avoid Select | Excel Programming | |||
Threaded Mode
