Userform Modal

[jstevens]

I have VBA code to show UserForm1 as modal and a number of checkboxes on the form that get set to true when various code is run. The challenge is that the UserForm and checkboxes all turn grey until the code completes.

Example Code:

Code: Select all

UserForm1.Show modal

Call Run_some_code_01
UserForm1.CheckBox1 = True
   UserForm1.Repaint

Call Run_some_code_02
UserForm1.CheckBox2 = True
   UserForm1.Repaint

Call Run_some_code_03
UserForm1.CheckBox3 = True
   UserForm1.Repaint

Call Run_some_code_04
UserForm1.CheckBox4 = True
   UserForm1.Repaint

I am repainting the UserForm after each section of code because the checkboxes may not display the check mark until the form is refreshed.

Your thoughts are appreciated.

[HansV]

For efficiency reasons, a userform is not updated while code runs unless you force it to using Repaint. I don't think there is a way around that.