Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
gr gr is offline
external usenet poster
 
Posts: 3
Default Tab Order on Form

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
Search this Thread:

Advanced Search
Display Modes

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
order form Abe Excel Worksheet Functions 3 January 30th 07 02:40 AM
order form Abe Excel Discussion (Misc queries) 3 January 30th 07 02:29 AM
i want a order form lindum services Excel Discussion (Misc queries) 1 January 23rd 07 12:07 AM
Order form to BOL? jpletting New Users to Excel 3 September 12th 05 02:35 PM
Order Form Scott MacLellan Excel Discussion (Misc queries) 1 April 28th 05 01:52 PM


All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"