View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert[_14_] Robert[_14_] is offline
external usenet poster
 
Posts: 11
Default 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