white_flag
02-24-2012, 02:54 AM
http://www.mrexcel.com/forum/showthread.php?p=3054951#post3054951
Hello
I like to add an progress bar when macro from excel is running and I putted like this:
A button in worksheet that will fire up UserForm1
in module:
Sub ShowMe1()
UserForm1.Show
End Sub
in userform I have a progressBar1
then, inside of the UserForm1
Sub UserForm_Initialize()
macro1
End Sub
Sub macro1()
'some code
UserForm1.ProgressBar1.Value = 10
'some code
UserForm1.ProgressBar1.Value = 20
'some code
UserForm1.ProgressBar1.Value = 30
' etc
UserForm1.ProgressBar1.Value = 100
Unload UserForm1
End Sub
This approach is correct? if is correct Why I have the following error.
UserForm1.show it is not showing
UserForm1.Show
Hello
I like to add an progress bar when macro from excel is running and I putted like this:
A button in worksheet that will fire up UserForm1
in module:
Sub ShowMe1()
UserForm1.Show
End Sub
in userform I have a progressBar1
then, inside of the UserForm1
Sub UserForm_Initialize()
macro1
End Sub
Sub macro1()
'some code
UserForm1.ProgressBar1.Value = 10
'some code
UserForm1.ProgressBar1.Value = 20
'some code
UserForm1.ProgressBar1.Value = 30
' etc
UserForm1.ProgressBar1.Value = 100
Unload UserForm1
End Sub
This approach is correct? if is correct Why I have the following error.
UserForm1.show it is not showing
UserForm1.Show