Hi all..
Is there a way to bypass the inputbox if the time has elapsed 30 seconds and nothing is entered in the Inputbox?
I'm using the following code.
[vba]Dim WeekNo As Integer
Dim WeekNo As Integer
Sub GetWeekno()
WkNo = 44
WeekNo = InputBox("Please Enter Week No. ", "Enter Week No. ", WkNo)
MsgBox WeekNo
End Sub
[/vba]
thnaks for all the help