View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Can you auto populate a cell by clicking on it?

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