arrun
02-21-2010, 12:09 AM
Hi all,
Here I am dealing with heavy calculations with VBA, so wanted to put a Userform saying that "calculation is going on". Here my goal is, just when calculations start that userform will pop-up and when it complete that will automatically hides. So I wrote following codes :
sub calculation()
userform1.show
.................................
calculations
.................................
userform1.hide
end sub
However this strategy seems not working. calculation() is not doing anything as long as userform1 is open. Once I close it manually then I get the results from calculation(), otherwise it doesn't.
What is the correct way to do that? Am I missing anything ? Your help will be highly appreciated.
Thanks
Here I am dealing with heavy calculations with VBA, so wanted to put a Userform saying that "calculation is going on". Here my goal is, just when calculations start that userform will pop-up and when it complete that will automatically hides. So I wrote following codes :
sub calculation()
userform1.show
.................................
calculations
.................................
userform1.hide
end sub
However this strategy seems not working. calculation() is not doing anything as long as userform1 is open. Once I close it manually then I get the results from calculation(), otherwise it doesn't.
What is the correct way to do that? Am I missing anything ? Your help will be highly appreciated.
Thanks