Thread
:
Screen is flashing when VBA adding objects into Excel sheet?
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Screen is flashing when VBA adding objects into Excel sheet?
application.screenupdating=false
reset to =true at end of macro
--
Don Guillett
SalesAid Software
Granite Shoals, TX
"d" wrote in message
...
I use VBA code to add Label, TextBox, and ComboBox into
the sheet1.
Everytime, when I open the application file and VBA adds
these objects in, the screen is flashing and adding one by
one, looks not good.
How can we make these object adding smoothly?
Thanks in advance!
d
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]