Re: User Form maneuvering
From: ross (rossmclean_at_rock.com)
Date: 05/06/04
- Next message: Tom: "Incrementing a receipt number in Excel 2003 VB form"
- Previous message: pgjoshi: "Application.Undo Problem"
- In reply to: Richard Mogy: "User Form maneuvering"
- Next in thread: Richard Mogy: "Re: User Form maneuvering"
- Messages sorted by: [ date ] [ thread ]
Date: 6 May 2004 03:35:50 -0700
Hi,
use the code
Me.TextBox1.SetFocus etc and some if statmets
Good luck
Ross
ALso see form help files:
Moves the keyboard focus to the specified command bar control so that
it can receive keyboard input. The kind of keyboard input you can
direct to the control depends on what type of control it is.
Note If the control is disabled or isn't visible from the current
state, this method will fail.
Syntax
expression.SetFocus
expression Required. An expression that returns a CommandBarControl,
CommandBarButton, CommandBarPopup, or CommandBarComboBox object.
- Next message: Tom: "Incrementing a receipt number in Excel 2003 VB form"
- Previous message: pgjoshi: "Application.Undo Problem"
- In reply to: Richard Mogy: "User Form maneuvering"
- Next in thread: Richard Mogy: "Re: User Form maneuvering"
- Messages sorted by: [ date ] [ thread ]
