View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lvcha.gouqizi lvcha.gouqizi is offline
external usenet poster
 
Posts: 38
Default 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