User Form maneuvering
From: Richard Mogy (rmogy_at_sbcglobal.net)
Date: 05/06/04
- Next message: Tom Ogilvy: "Re: Issuing DOS command in VBA macro?"
- Previous message: Tom Ogilvy: "Re: slow sorting worksheets"
- Next in thread: Jean-Yves: "Re: User Form maneuvering"
- Reply: Jean-Yves: "Re: User Form maneuvering"
- Reply: ross: "Re: User Form maneuvering"
- Reply: Richard Mogy: "Re: User Form maneuvering"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 06 May 2004 02:52:28 GMT
I have created a user form with five text boxes.
The user is asked first to enter two numbers. After the second number is
entered, I check if the second number is greater than or equal to the first.
If it isn't, then I blank out both boxes, display a message and then I want
the cursor to go to the first box so the user can re-enter the range.
The problem is getting the cursor back to the first box.
I then have the user enter two dates in the third and fourth box. I do
similar checks to determine that the second date is greater than or equal to
the first date and if not, blank out both boxes, display a message. I then
want the cursor to go to the third box.
Any suggestions would be appreciated.
- Next message: Tom Ogilvy: "Re: Issuing DOS command in VBA macro?"
- Previous message: Tom Ogilvy: "Re: slow sorting worksheets"
- Next in thread: Jean-Yves: "Re: User Form maneuvering"
- Reply: Jean-Yves: "Re: User Form maneuvering"
- Reply: ross: "Re: User Form maneuvering"
- Reply: Richard Mogy: "Re: User Form maneuvering"
- Messages sorted by: [ date ] [ thread ]