Forum menu
Topic starter
I have a excel vba file. On open it calls a user form, the purpose of which is two fold. First the user form has a button to run a macro, second it tells the user what to do. But what I need to do is for the user to be able to amend the worksheet before running the macro.
At the moment the user form is not allowing me to select the worksheet behind without closing it. Can anyone offer any advice?
Posted : 10/05/2011 10:50 am
UserForm.Show vbModeless
That should do it I think.
Posted : 10/05/2011 10:53 am
Topic starter
Thank you very much, did the job.
Posted : 10/05/2011 11:01 am
Yay! 😀
Posted : 10/05/2011 11:03 am