Prev: run macro after userform unloads
Next: Cant change FirstPageTray of Word Document
From: spunkymuffmonkey on 22 Dec 2009 04:15
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
From: Fumei2 via OfficeKB.com on 22 Dec 2009 15:42
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


spunkymuffmonkey wrote:
>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

--
Message posted via http://www.officekb.com

 | 
Pages: 1
Prev: run macro after userform unloads
Next: Cant change FirstPageTray of Word Document