Can you auto populate a cell by clicking on it?

[BethAnn]

I wish to have a symbol auto pop when a salesman clicks on space bar in a
cell. (i.e. a phone if he made a phone call, etc.) Reasoning, it's a salesman
and if he sees a phone twice, maybe it'll cut down on mistakes.... It's a
basic spreadsheet with options for client contact... just 3, can't make it to
confusing.
I'm not the sharpest tack in Excel but I can follow directions & would
appreciate any help.Tks.

 

[Gary''s Student]

First insert these macros and then run the keyset macro:

Sub keyset()
Application.OnKey " ", "hello"
End Sub

Sub hello()
ActiveCell.Value = "a"
ActiveCell.Font.Name = "Marlett"
End Sub

If you then click on a cell and then touch the spacebar, a checkmark will
appear in the cell.

 

[Gord Dibben]

If you really want a phone.........

Sub hello()
ActiveCell.Value = Chr(40)
ActiveCell.Font.Name = "Wingdings"
End Sub


Gord Dibben MS Excel MVP