 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Chat Forum
3
Posts
2
Users
0
Reactions
50
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