Thread: Dialog Box
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Francis Ang[_3_] Francis Ang[_3_] is offline
external usenet poster
 
Posts: 75
Default Dialog Box

Thank you. Appreciate your efforts.

"OssieMac" wrote:

I have no further suggestions.
--
Regards,

OssieMac


"Francis Ang" wrote:

I use 'Application.ScreenUpdating=False' because i do not want the user to
view the file running behind the dialog box.

"OssieMac" wrote:

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?