Y
Yusuf Godil
I was using Widows Me and Office XP till recently but now I have new HP
notebook in which there is Windows XP and Office XP. I have transferred all
my old excel files to new computer and facing a small problem which I do not
know whether it is because of operating system or some setting in operating
system or problem is in excel.
In my excel file there is VBA macro in which there are 3 to 4 inputboxes
which are appearing one after other and as I know what will be asked next,
in my old computer after inputting information in first inputbox, during
delay due to information getting processed by excel it was not necessary to
wait till next inputbox to appear and if any information was typed and enter
button was pressed the information was accepted by the program for next
inputbox. All those inputboxes for which already information was entered
were not even appearing on screen unless and until there was enough delay on
my part during which excel was able to process the information.
In my new computer it is not possible to enter the information as above
till inputbox appears on the screen. As code in my program is very lengthy I
am giving below code made by me for checking purpose so that somebody can
tell me how to tackle this problem
Public Sub check_inputbox()
For job = 0 To 3 ' 4 inputboxes will appear one after other
Range("a1").Offset(job) = Application.Input(job + 1) 'information put into
inputboxes will be transferred to "A1" to "A4"
For i = 0 To 50000 'delay for next inputbox to appear
Application.StatusBar = i '' display in statusbar
Next
Next
Application.StatusBar = False
End Sub
In above example if I try to enter data in quick succession, w/o inputbox on
screen during delay set as above either no information or wrong information
is getting entered in the cells.
Any help will be highly appreciated.
Yusuf Godil
notebook in which there is Windows XP and Office XP. I have transferred all
my old excel files to new computer and facing a small problem which I do not
know whether it is because of operating system or some setting in operating
system or problem is in excel.
In my excel file there is VBA macro in which there are 3 to 4 inputboxes
which are appearing one after other and as I know what will be asked next,
in my old computer after inputting information in first inputbox, during
delay due to information getting processed by excel it was not necessary to
wait till next inputbox to appear and if any information was typed and enter
button was pressed the information was accepted by the program for next
inputbox. All those inputboxes for which already information was entered
were not even appearing on screen unless and until there was enough delay on
my part during which excel was able to process the information.
In my new computer it is not possible to enter the information as above
till inputbox appears on the screen. As code in my program is very lengthy I
am giving below code made by me for checking purpose so that somebody can
tell me how to tackle this problem
Public Sub check_inputbox()
For job = 0 To 3 ' 4 inputboxes will appear one after other
Range("a1").Offset(job) = Application.Input(job + 1) 'information put into
inputboxes will be transferred to "A1" to "A4"
For i = 0 To 50000 'delay for next inputbox to appear
Application.StatusBar = i '' display in statusbar
Next
Next
Application.StatusBar = False
End Sub
In above example if I try to enter data in quick succession, w/o inputbox on
screen during delay set as above either no information or wrong information
is getting entered in the cells.
Any help will be highly appreciated.
Yusuf Godil