Is there any way to switch among different sheets in a workbook while an inputbox is popped?

Hi all,

It seems that when an inputbox is up, we can not switch among sheets
any more. This is really not convenient because maybe users need to
check what to input in an inactive sheet. Is there any way to solve
that?

Dim checkIndex As Integer
On Error Resume Next
checkIndex = InputBox("please input the index")
On Error GoTo 0
Call plotsth(checkIndex)


lvcha

Hi Ivcha,

Try using Excel's input box:

Application.InputBox.

For details, see VBA help on the InputBox method.

---
Regards,
Norman



"lvcha.gouqizi" <[email protected]> wrote in message
news:[email protected]...
> Hi all,
>
> It seems that when an inputbox is up, we can not switch among sheets
> any more. This is really not convenient because maybe users need to
> check what to input in an inactive sheet. Is there any way to solve
> that?
>
> Dim checkIndex As Integer
> On Error Resume Next
> checkIndex = InputBox("please input the index")
> On Error GoTo 0
> Call plotsth(checkIndex)
>
>
> lvcha
>