Scrolling a page when MsgBox is appearing

**vivekchha** · 07-13-2010, 09:44 PM

When a message box appears the scrolling of underlying page gets locked. Will you please tell me how I can enable the page scrolling when msgbox is appearing.
Thanks.
vivek

**Leith Ross** · 07-13-2010, 09:52 PM

Hello vivekchha,

It is the nature of the message box to disable input to the application that invoked it. Input is returned to the application once the user has responded to the message box. The easiest way to create a message box that will allow the user to interact with the application is to create a UserForm and set the ShowModal property to false.

**vivekchha** · 07-14-2010, 10:30 AM

Thanks Ross,
Is it the same case with inputbox?

**Leith Ross** · 07-14-2010, 12:11 PM

Hello vivekchha,

Yes, the same action applies to an InputBox. However, there is another InputBox, Application.InputBox, that allows you scroll the worksheet to select cells. Is this what you are looking for?

**vivekchha** · 07-15-2010, 11:42 AM

Thanks Ross,
You have got my point. I think this will solve my problem.
P.S. I have used the application.inputbox and my problem has been solved. Please mark it as solved.
Thanks a lot again.
vivekchha