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.
thnaks for all the helpDim WeekNo As Integer Dim WeekNo As Integer Sub GetWeekno() WkNo = 44 WeekNo = InputBox("Please Enter Week No. ", "Enter Week No. ", WkNo) MsgBox WeekNo End SubFormatting tags added by mark007