Results 1 to 1 of 1
Thread: Tab Order in VBA
2001-03-28, 03:47 #1
- Join Date
- May 2002
- Wellington, North Island, New Zealand
- Thanked 0 Times in 0 Posts
Tab Order in VBA
I have a strange one for you to look at...
I have a VBA form (Excel 2000) that has multipages and frames in it.
I have attached it in as basic a form as posible so you can have a look at the problem and make some suggestions
I am trying to validate my textbox input before moving on.
My problem is that I lose control of the tab order!!!
I.E. When I tab out of a control that I am validating, if the control is the last in the frames taborder that is enabled then it tabs to the next frame, even if I change the enabled status of the next control before I leave the event procedure. Also some events don't fire in this instance, ie the AfterUpdate and Exit events and KeyUp events don't fire!!!!
So have a go at entering amounts in the instalments, and try and get the tab order working correctly.
I have pulled my hair out trying to figure it out.