View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
cincode5 cincode5 is offline
external usenet poster
 
Posts: 3
Default How Does VBA Know Which Cell Its On

Awesome, how simple was that...

Thanks Don.
--
Regards...


"Don Guillett" wrote:

msgbox activecell.address


--
Don Guillett
SalesAid Software

"cincode5" wrote in message
...
Just curious to know something. If I were to select any cell on a
worksheet,
how does VBA know what that cell is. In other words, I know I can select
a
cell from a macro using Range("A1").Select, for example, but what would
the
line of code be that activates or identifies a cell when I click on it.
Does
that make sense?
--
Regards...