Blank Userform

[spunkymuffmonkey]

Hi all,

I have a slight problem, I have some code which adds rows with formfields in
to a table in a protected form. These formfields have text in which is
dependant upon users ticking checkboxes. Before adding the rows my code
checks to see if particular rows have already been added to the table so that
these rows are not added again.

The whole macro takes about 30 seconds to run and to save users seeing Word
'dance' and the screen flash, I have tried to utilise a userform to appear
for the duration of the code.

Unfortunately the body of the userform turns blank whilst the code is
executed and I wondered how I could combat this.

I have tried using the repaint function and tried amending the userforms
drawbuffer property but neither seem to solve this problem, plus I don't know
really what I'm doing with these properties/methods.

Any help would be gratefully received.

Thanks

 

[Fumei2 via OfficeKB.com]

I am little confused by "These formfields have text in which is
dependant upon users ticking checkboxes. "

Formfields are usually used to input text by the user. Are you saying you
are putting text in programmatically. Why?

In any case regarding flicker, you can try Application.ScreenUpdating = False