Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any way to switch among different sheets in a workbook while an inputbox is popped?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Switch between sheets with keystrokes? | Excel Worksheet Functions | |||
Cannot switch between sheets... | Excel Discussion (Misc queries) | |||
Is there a faster way to switch between sheets? | Excel Discussion (Misc queries) | |||
switch between sheets | Excel Discussion (Misc queries) | |||
how do i switch between multiple sheets in the same workbook (key. | Excel Discussion (Misc queries) |