| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
endless loop - using input box
Cleaner Still:
partNum = InputBox("Please enter the part number", "Part Number", 0) Sheets("Sales").Range("B1").Value = PartNum While Sheets("Sales").Range("B1").Text = "#N/A" Output = MsgBox("You have entered an invalid Part Number", vbRetryCancel, "Invalid Number") If Val(Output) = vbCancel Then Exit Sub Loop |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting endless loop on DoUntil | Excel Programming | |||
| Endless loop | Excel Programming | |||
| endless loop help | Excel Programming | |||
| Endless loop? | Excel Programming | |||
| Interrupting an endless loop | Excel Programming | |||
Threaded Mode
