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