Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having some difficulty with this one.
I have a form that has "columns" on it. These are text boxes for 5 different items. The columns a Qty UOM Description Amount Initially the QTY is set to 0 on all the rows and the Enabled property is false on UOM/Desc/Amount. If the user changes the QTY to a non zero amount, the rest of the column becomes enabled=true. Then I want the UOM to get the focus. But it doesn't. It goes to the QTY of the next line. I have the tab stop values setup correctly going left to right per line. I have played with putting the following code in all the different events, but to no avail. ------ If Val(txtMisc1Qty.Text) = 0 Then txtMisc1Desc.Enabled = False txtMisc1UOM.Enabled = False txtMisc1OverRide.Enabled = False txtMisc1AddlProfit.Enabled = False Else txtMisc1Desc.Enabled = True txtMisc1UOM.Enabled = True txtMisc1OverRide.Enabled = True txtMisc1AddlProfit.Enabled = True 'txtMisc1UOM.SetFocus End If ------ I have put it in the following events, and as I can tell, this is the order that they fire in. ---- 'Order 'Enter 'Change 'Before_Update 'After_Update 'Exit Thanks in advance Guy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
order form | Excel Worksheet Functions | |||
order form | Excel Discussion (Misc queries) | |||
i want a order form | Excel Discussion (Misc queries) | |||
Order form to BOL? | New Users to Excel | |||
Order Form | Excel Discussion (Misc queries) |