nonmodal? - Message box without halting macro

[selkov]

I have searched thru many posts but can't get seem to find how to just display a text box/msg that says something simple like pls wait - processing while the macro runs.

Any Ideas?

 

[Jaafar Tribak]

I have searched thru many posts but can't get seem to find how to just display a text box/msg that says something simple like pls wait - processing while the macro runs.

Any Ideas?

Have you tried using a modeless userform for displaying the message ?

 

[selkov]

I tried but could not get it to work.

 

[My Aswer Is This]

Show us your script. Including the part with your Userform message.
It should look something like this:

Userform1.show modeless

my script here

Unload userform1

I tried but could not get it to work.

 

[selkov]

Please see below, Thanks

Private Sub Workbook_Open()

userform1.Show modeless
PLEASE WAIT UPDATING THE DATA

Workbooks(ThisWorkbook.Name).RefreshAll
Unload userform1

userform2.Show modeless
PLEASE WAIT WHILE WE refresh your page
ActiveSheet.PivotTables(1).PivotCache.Refresh

Unload userform2


'

End Sub

 

[My Aswer Is This]

The ideal is:

1.You make a userform
2. On the Userform you enter the text you want seen using a label or textbox
3. When the Userform pops up the user sees the message.

You would not have this line of code in your script:
"PLEASE WAIT UPDATING THE DATA"

Please see below, Thanks

Private Sub Workbook_Open()

userform1.Show modeless
PLEASE WAIT UPDATING THE DATA

Workbooks(ThisWorkbook.Name).RefreshAll
Unload userform1

userform2.Show modeless
PLEASE WAIT WHILE WE refresh your page
ActiveSheet.PivotTables(1).PivotCache.Refresh

Unload userform2


'

End Sub

 

[My Aswer Is This]

Actually you would need to Use a label on your UserForm.
Or a textbox. But if you use a textbox you would need a script in the userform to load the data into the Textbox.

 

[selkov]

This is something I have never done. Can you post an example?

 

[My Aswer Is This]

Are you saying you have never made a Userform?

This is something I have never done. Can you post an example?

 

[selkov]

yes