Messagebox which allows the user to scroll through the sheet.

[Vamsi]

Hi,

In Excel 2003 i am writing a Macro. The user opens an
Excel file when he clicks on a button.

My question is the user should be able to check for some
perticular data before he can proceed to the next step. I
need to prompt with the "Data that needs to be checked"
and if the data is fine the user will click "YES" which
takes him to the next step,, else when the user
clicks "NO" he will be taken to the sheet where he needs
to change the data.

When i try to use Msgbox command for doing this, this
doesn't let the user to scroll through the sheet and chk
for the data.

Can someone pls advice how do i handle this.

Thanks in advance for any help.

Vamsi.

 

[Guest]

The only two modality options of a msgbox both make the application unusable while the message box is around.

Why not just evaluate the values yourself using the macro? Or put them in the message box, so the user can click yes/no

You could create a UserForm that resembles a message box and set its "ShowModal" property to False so that they can interact with Excel while the form is open

HTH

-Brad Vontur