I've added a checkbox to a form and assigned a macro that totally
changes the behaviour of the form if the checkbox is ticked. I've
locked all cells on the form as necessary so that the user simply uses
the tab key to move to the next cell requiring data entry. The problem
is that the checkbox must be mouseclicked to tick it. I'd like to be
able to select it with the tab key and use the spacebar to tick it. Is
this possible?

BrianG


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Whan you say "form", I assume you mean a worksheet that acts as a form and
not a UserForm. If so, there is no straightforward way to select a control
on a worksheet by tabbing.

For example, when you have a range selected on the worksheet and then you
press the Tab key, how would Excel know whether you want the normal Tab key
behavior, or selection of the control?

--

Vasant






"BrianG" wrote in message
...
I've added a checkbox to a form and assigned a macro that totally
changes the behaviour of the form if the checkbox is ticked. I've
locked all cells on the form as necessary so that the user simply uses
the tab key to move to the next cell requiring data entry. The problem
is that the checkbox must be mouseclicked to tick it. I'd like to be
able to select it with the tab key and use the spacebar to tick it. Is
this possible?

BrianG


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Vasant,

It can be done if the object is selected, and then use a key event for that
object to trap the tab key, and tab to another pre-defined object. Kludgy,
but it works on control toolbox objects (never tried to make it work for
forms objects as you can't get at the events).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Whan you say "form", I assume you mean a worksheet that acts as a form and
not a UserForm. If so, there is no straightforward way to select a control
on a worksheet by tabbing.

For example, when you have a range selected on the worksheet and then you
press the Tab key, how would Excel know whether you want the normal Tab
key
behavior, or selection of the control?

--

Vasant






"BrianG" wrote in message
...
I've added a checkbox to a form and assigned a macro that totally
changes the behaviour of the form if the checkbox is ticked. I've
locked all cells on the form as necessary so that the user simply uses
the tab key to move to the next cell requiring data entry. The problem
is that the checkbox must be mouseclicked to tick it. I'd like to be
able to select it with the tab key and use the spacebar to tick it. Is
this possible?

BrianG


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Bob:

Yes, I've seen that workaround. But the way I read it, the OP had a checkbox
that he wanted to tab to from the worksheet (he said he was tabbing from
cell to cell for data entry).

Perhaps I was over-interpreting the post ... it wouldn't be the first time!
<g

Regards,

Vasant.

"Bob Phillips" wrote in message
...
Vasant,

It can be done if the object is selected, and then use a key event for
that
object to trap the tab key, and tab to another pre-defined object. Kludgy,
but it works on control toolbox objects (never tried to make it work for
forms objects as you can't get at the events).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Whan you say "form", I assume you mean a worksheet that acts as a form
and
not a UserForm. If so, there is no straightforward way to select a
control
on a worksheet by tabbing.

For example, when you have a range selected on the worksheet and then
you
press the Tab key, how would Excel know whether you want the normal Tab
key
behavior, or selection of the control?

--

Vasant






"BrianG" wrote in message
...
I've added a checkbox to a form and assigned a macro that totally
changes the behaviour of the form if the checkbox is ticked. I've
locked all cells on the form as necessary so that the user simply uses
the tab key to move to the next cell requiring data entry. The
problem
is that the checkbox must be mouseclicked to tick it. I'd like to be
able to select it with the tab key and use the spacebar to tick it.
Is
this possible?

BrianG


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Vasant,

I wasn't really suggesting this for the OP (it gets very cumbersome), but
just making sure that you knew for your reference. Like to keep up the
contact with regulars<vbg

Bob

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Hi Bob:

Yes, I've seen that workaround. But the way I read it, the OP had a
checkbox
that he wanted to tab to from the worksheet (he said he was tabbing from
cell to cell for data entry).

Perhaps I was over-interpreting the post ... it wouldn't be the first
time!
<g

Regards,

Vasant.

"Bob Phillips" wrote in message
...
Vasant,

It can be done if the object is selected, and then use a key event for
that
object to trap the tab key, and tab to another pre-defined object.
Kludgy,
but it works on control toolbox objects (never tried to make it work for
forms objects as you can't get at the events).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Whan you say "form", I assume you mean a worksheet that acts as a form
and
not a UserForm. If so, there is no straightforward way to select a
control
on a worksheet by tabbing.

For example, when you have a range selected on the worksheet and then
you
press the Tab key, how would Excel know whether you want the normal
Tab
key
behavior, or selection of the control?

--

Vasant






"BrianG" wrote in message
...
I've added a checkbox to a form and assigned a macro that totally
changes the behaviour of the form if the checkbox is ticked. I've
locked all cells on the form as necessary so that the user simply
uses
the tab key to move to the next cell requiring data entry. The
problem
is that the checkbox must be mouseclicked to tick it. I'd like to
be
able to select it with the tab key and use the spacebar to tick it.
Is
this possible?

BrianG


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Thanks for the responses. Glad I was able to spark a little tet-a-tet
amongst the regulars<g.

--
BrianG



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Like to keep up the
contact with regulars

Yep, that's what I enjoy most about this group (next to spending an hour to
come up with a creative solution for someone and never getting any
feedback!).

--

Vasant


"Bob Phillips" wrote in message
...
Hi Vasant,

I wasn't really suggesting this for the OP (it gets very cumbersome), but
just making sure that you knew for your reference. Like to keep up the
contact with regulars<vbg

Bob

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Hi Bob:

Yes, I've seen that workaround. But the way I read it, the OP had a
checkbox
that he wanted to tab to from the worksheet (he said he was tabbing from
cell to cell for data entry).

Perhaps I was over-interpreting the post ... it wouldn't be the first
time!
<g

Regards,

Vasant.

"Bob Phillips" wrote in message
...
Vasant,

It can be done if the object is selected, and then use a key event for
that
object to trap the tab key, and tab to another pre-defined object.
Kludgy,
but it works on control toolbox objects (never tried to make it work
for
forms objects as you can't get at the events).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Whan you say "form", I assume you mean a worksheet that acts as a
form
and
not a UserForm. If so, there is no straightforward way to select a
control
on a worksheet by tabbing.

For example, when you have a range selected on the worksheet and
then
you
press the Tab key, how would Excel know whether you want the normal
Tab
key
behavior, or selection of the control?

--

Vasant






"BrianG" wrote in message
...
I've added a checkbox to a form and assigned a macro that totally
changes the behaviour of the form if the checkbox is ticked. I've
locked all cells on the form as necessary so that the user simply
uses
the tab key to move to the next cell requiring data entry. The
problem
is that the checkbox must be mouseclicked to tick it. I'd like to
be
able to select it with the tab key and use the spacebar to tick
it.
Is
this possible?

BrianG


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!