Quick userform question.
 

I have created a multi-field userform that works fine. However, I am trying
to figure out how to have the cursor automatically appear in the first field
each time I send my fields to a table. I could probably create an
accelerator button for that field and write a quick code for that shortcut,
but I am sure that there is something simpler out there that I'm not hitting
on.

Thank you for your responses!!

Quick userform question.
 

You can use the SetFocus method of the control.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"VB Newbie" wrote in message
...
I have created a multi-field userform that works fine. However,
I am trying
to figure out how to have the cursor automatically appear in
the first field
each time I send my fields to a table. I could probably create
an
accelerator button for that field and write a quick code for
that shortcut,
but I am sure that there is something simpler out there that
I'm not hitting
on.

Thank you for your responses!!

Quick userform question.
 

Thank you, Chip, for pointing me in the right direction!!

"Chip Pearson" wrote:

You can use the SetFocus method of the control.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"VB Newbie" wrote in message
...
I have created a multi-field userform that works fine. However,
I am trying
to figure out how to have the cursor automatically appear in
the first field
each time I send my fields to a table. I could probably create
an
accelerator button for that field and write a quick code for
that shortcut,
but I am sure that there is something simpler out there that
I'm not hitting
on.

Thank you for your responses!!