Thread: active cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default active cell

Hi Steph,
Are you trying to have "ok" automatically entered into a cell
merely by landing (activating) a cell in Column 3. If so you
would use an Event macro.
http://www.mvps.org/dmcritchie/excel/event.htm

If might be safer to use a doubleclick to trigger your event
macro.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Steph" wrote...
Based upon the active cell, how can I type the word "ok" into column 3?

So basically, I need to determine the row the active cell is in, and then
use that row and column 3 as the target for the "ok" text. Thanks!