Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop in Excel?
I'm trying to write a macro that will loop a process.
i.e. a text box pops up and asks "What sheet do you want to pull data from?" and if the name is incorrect, it'll show that name is incorrect and loops back to the beginning askin what sheet they want to pull the data from again. If the sheet entered matches, it will go directly to that sheet in the workbook. I was thinking maybe it's better to use a SELECT Case and have it evaluate whether or not the text entered equals any of the sheet names in the workbook. Any ideas? Thanks in advance, Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop in Excel | Excel Discussion (Misc queries) | |||
How to Loop a macro in Excel | New Users to Excel | |||
Excel VBA loop until eof | Excel Programming | |||
Loop within Excel Formula? | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |