UserForm - display text message then run code
In message , Robert writes
I have a UserForm which runs some code for around 2 minutes. When the
CommandButton is activated I want a short message to display in a
TextBox on the UserForm throughout the time the code is running.
Even though 'TextBox1.Text = "selection running" is placed at the
beginning the message does not appear until all the process has
finished running.
Grateful for any suggestions.
Many thanks for the suggestions - DoEvents has solved the problem.
--
Robert
|