I do not think this can be done as there is no Cell_Click method that I can
find.

"art" wrote:

Hello:

Is there a way that I can make through anyway (macro, VBA) that when I
select a cell, it should automatically fill in the number 1. and If I select
the cell twice the cell should fill in the number 2. Any help would be
appriciated.