pass 'focus' from form to sheet

[beckstei]

I have a form which opens when the spreadsheet opens. I want the form to be open in vbmodeless and for cell F2 to be 'active'. By that I mean I want the behavior to be the same as if I clicked in cell F2. Right now the form keeps the focus and the cell is not 'clicked in' even though my macro tells me that the active cell is F2.

In newbie speak, b/c that's what I am, I want the bar at the top of the form to be gray and not blue which is what happens when I physically click in cell F2.

Sorry for such a lame description.

Here's the code that exists in the form now:

Please Login or Register  to view this content.

Thanks
B

[mudraker]

Try:

UserForm1.Show vbModeless

This allows the user to enter data on the work sheet and also if form is
used to enter data through it.


This is suggestion was extracted from

http://www.excelforum.com/showthread.php?t=350257