PDA

View Full Version : switching focus from userform to spreadsheet?



nyteflyte
06-17-2007, 09:31 AM
i am having alot of trouble doing this...:banghead: and im just not quite sure how i can change the focus from a form to the spreadsheet. because what i have so far is a form w/ a button on it that creates a table when the button is clicked, then i want the program to allow the user to input information in the table and then press the calculate button.. any help would be great!

Bob Phillips
06-17-2007, 09:47 AM
When you show the form,, show it modeless

Userform1.Show vbModeless

nyteflyte
06-17-2007, 09:52 AM
so.. this will help me go from the form to the spreadsheet?

nyteflyte
06-17-2007, 10:02 AM
YES! its works thank you so much!