Hi Ivcha,

Try using Excel's input box:

Application.InputBox.

For details, see VBA help on the InputBox method.

---
Regards,
Norman



"lvcha.gouqizi" wrote in message
oups.com...
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