Showing UserForm to Indicate Progress, Macro Doesn't Run Until I Exit UserForm

**EnigmaMatter** · 10-09-2014, 08:35 PM

Hello,

I am using a UserForm with 1 Label to show what step is being processed. However, the macro doesn't run until I exit the UserForm! How do I get a Macro to run automatically, while the UserForm is being displayed?

Please Login or Register  to view this content.

**duncandhu** · 10-09-2014, 09:04 PM

Hi EnigmaMatter,

I haven't tested this method, but is it possible to call the HighlightReceived from the Userform_Initialize event?

Thanks,
Duncan

**AlphaFrog** · 10-09-2014, 09:35 PM

Try this...

Please Login or Register  to view this content.

**EnigmaMatter** · 11-21-2014, 07:00 PM

Worked wonderfully. Sorry for the delay.

Showing UserForm to Indicate Progress, Macro Doesn't Run Until I Exit UserForm

LinkBack

Thread Tools

Rate This Thread

Display

Showing UserForm to Indicate Progress, Macro Doesn't Run Until I Exit UserForm

Re: Showing UserForm to Indicate Progress, Macro Doesn't Run Until I Exit UserForm

Re: Showing UserForm to Indicate Progress, Macro Doesn't Run Until I Exit UserForm

Re: Showing UserForm to Indicate Progress, Macro Doesn't Run Until I Exit UserForm

Thread Information

Users Browsing this Thread

Similar Threads

Texbox exit event prevents userform exit

Exit Userform to return to main code, but keep userform open

Progress Bar UserForm and/or Progress Bar Conditional Formatting

showing the userform again when userform hasn't been hidden or unloaded

[SOLVED] Looping procedure calls userform; how to exit loop (via userform button)?

Bookmarks

Bookmarks

Posting Permissions