Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Chat Forum
3
Posts
2
Users
0
Reactions
53
Views
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 9:50 am
UserForm.Show vbModeless
That should do it I think.
Posted : 10/05/2011 9:53 am
Topic starter
Thank you very much, did the job.
Posted : 10/05/2011 10:01 am
Yay! 😀
Posted : 10/05/2011 10:03 am