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.

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.

--
Gary''s Student - gsnu200840


"BethAnn" wrote:

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

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

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


Gord Dibben MS Excel MVP

On Wed, 18 Mar 2009 12:23:07 -0700, Gary''s Student
<(E-Mail Removed)> wrote:

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