Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am currently setting properties for a number of form controls based on
conditions in a worksheet. I've labeled the form controls using numeric values in the hopes that there may be some way to programmatically reference them (as with INDIRECT) and reduce the amount of code. Here is a sample of the code used so far (I've snipped out middle sections to reduce size in this example): If Range("T21").Value 0 Then 'Prep OtherEntry form frmOtherEntry.fr1.Enabled = (Range("F21").Value 0) frmOtherEntry.fr2.Enabled = (Range("G21").Value 0) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
setting cell values based on a 3rd cell | Excel Worksheet Functions | |||
Dynamically setting CELL COLORS based on TWO OTHER cell values | Excel Discussion (Misc queries) | |||
Setting properties of userform controls with VBA | Excel Programming | |||
Setting form controls focus and enter key | Excel Programming | |||
Accessing the values of form controls on worksheets in Excel 2000 | Excel Programming |