Thread: Dialog Box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Dialog Box

Have you tried without Application.ScreenUpdating=False

That command is usually only used where extensive processing is to take
place and lots of processing time can be saved by not having to continually
update the screen. It also stops the screen continually flashing with new
info when extensive processing is taking place which can be annoying to the
user. I wonder why you need it just to bring up a dialog box.

--
Regards,

OssieMac


"Francis Ang" wrote:

I have the following program codes-

Application.ScreenUpdating=False
Dialogbox.Show

When the user moves the dialogbox, it messes up the screen. How do I stop a
user from moving the dialog box?