Hi Guys,
i have user form running but when i want to run second macro code i am getting error.
It is ok because i can not 2 different codes in the same time.
I would like to:
1) run userform as seperate instance
2) use this useform on activeworkbook
3) run otther macros in the same time without any errors.
How can i do this? I do not want to add ane external workbooks but i could have some kind of hidden workbook opened from master one.
Please advice,
Jacek
You should explore Opening the Userform using the command:
Userform1.show vbModeless
So you can select your spread sheet while the userform is open. Do what you need to do in Excel and return to the Userform.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
mehmetcik thanks but you can not run another procedures in VBA when userform is opened.
And this is what i need.
Best,
Jacek
Yes, you can.
Everyone who confuses correlation and causation ends up dead.
Thank you Rory.
Ok it is strange maybe this is connected with my specific userform,
i created seperated test and worked...
Best,
Jacek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks