Text field visible property on user form

Hi,

I have a text field at the bottom of a user form that remains hidden (i.e. visible = false) until the user clicks the "Ok" button. At that point, I want the text field to appear as the macro is running (it's a large macro, so the text field just says "processing, please wait...").

The first line of my macro is:

Please Login or Register  to view this content.

Where CostSummSettings.Processing is the text field. The rest of the code comes after that line. The user form doesn't close until the end of the macro, so the form should stay open with this text field displayed on it as the macro is running. However, when the user clicks OK and the macro is run, the text field is not appearing on the form. I've isolated and tested that line of code and it works on its own, but not when it's combined with the rest of the code.

Can't figure out why. Any suggestions? Thanks in advance.

Hello JChandler22,

Try this. Change the name of UserForm1 to the name of your user form.

Please Login or Register  to view this content.