| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting out of a if loop
hi All,
I have a VBA code for a change event associated with a particular cell, say A1. If the value in A1 is less than 500 a message box is displayed that you have to enter something freater than 500. If it is less than 500 I want the value of A1=0. But now since 0 is less than 500 code goes into an infinite loop of showing the msgbox. How do I get out of this loop. Any help or guidance is appreciated. Thanks, RK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
| Loop gone crazy | Excel Discussion (Misc queries) | |||
| Do Loop | Excel Discussion (Misc queries) | |||
| hysteresis loop | Charts and Charting in Excel | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
Threaded Mode
