Thread: Link cell contents to a Macro?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Link cell contents to a Macro?
This can be accomplished by using a Worksheet_SelectionChange macro. This
macro will run whenever a given cell is selected.

If you are not familiar with even macros, see:



http://cpearson.com/excel/events.htm
--
Gary's Student


"Dave" wrote:

I'd like to call a macro that sorts a list simply by clicking on a header cell.
Sort Key1 = the cell that the user clicks on.
Can one call a macro by clicking on a cell or the contents of a cell?
If so, how?
Thanks very much.

Reply With QuoteReply With Quote