Dialog Box

[Francis Ang]

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?

 

[OssieMac]

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.

 

[Francis Ang]

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

 

[OssieMac]

I have no further suggestions.

 

[Francis Ang]

Thank you. Appreciate your efforts.

I have no further suggestions.

 

[Héctor Miguel]

hi, Francis !

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?

op1: put the screenupdating on true BEFORE show the dialog
add a line w/ screenupdating on false AFTER the show line

op2: try w/ a userform and some API calls to remove the userform title

hth,
hector.

 

[Francis Ang]

Hi Miguel,

Thanks for the suggestion. I will try Option2 as I know how to do that.