how can a macro be triggered by the entry of certain figures in a cell.
Posted by Natalie Greppi on December 21, 2001 12:27 AM
how can a macro be triggered by the entry of certain figures in a cell.
how it can do different things based on the entered data.
after the macro finish the function the input cell is cleared for the input of new figure.
how can I make a macro that sorts columns based on a certain criteria that is triggered by a certain condition.
several macros that work based on a letter in cell. Performs different things based on what is in the cell then clears the letter automically awaiting the input of another.
Posted by Jacob on December 21, 2001 5:00 AM
Hi
Check out the worksheet_change event
sub worksheet_change
if this is that then
else
etc
end sub
