View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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