Posted to microsoft.public.excel.programming

tim

external usenet poster

Posts: 105

User Form

Got it thanks

-----Original Message-----
Hello All,

I have a user form that inputs data into a worksheet
upon
clicking a command button. After I click the button, I
would like my userform to be active (not my spreadsheet)
and the cursor returned to the first tabstop.

BTW:My userform is modeless as other forms can be opened
and utilized.

I think this has something to do with TakeFocus?

Thanks in advance.
.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User Form	Joanne	Excel Discussion (Misc queries)	1	June 26th 07 02:26 PM
How do I fill a cell in a user form from a selection on same form?	Terry Tipsy	Excel Discussion (Misc queries)	4	June 11th 07 02:59 PM
user form	static69	Excel Discussion (Misc queries)	1	February 6th 05 08:43 PM
user form	Bill[_19_]	Excel Programming	0	October 23rd 03 04:32 AM
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form	BruceJ[_2_]	Excel Programming	2	October 15th 03 05:28 PM

All times are GMT +1. The time now is 02:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us