How Does VBA Know Which Cell Its On
 

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...

How Does VBA Know Which Cell Its On
 

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...

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...

How Does VBA Know Which Cell Its On
 

it's only simple when you know how

--
Don Guillett
SalesAid Software

"cincode5" wrote in message
...
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...