I'm not sure what you're asking, but if that cell changes by typing, you could
use a worksheet_change event to fire the other macros.
If you want to read more about these kinds of events:
Chip Pearson's site:
http://www.cpearson.com/excel/events.htm
David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm
If you meant you wanted to check in your macro for the value in that cell...
if lcase(worksheets("Sheet1").range("a1").value) = "local" then
'do one thing
else
'do a different thing
end if
Mike F. wrote:
Is there a way to have a macro run based on the condition of a cell or a
toggle button? Examlpe, if Type = Local then the macros on sheet 2 that are
needed for long estiamtes will automatically run.
--
Dave Peterson