Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto populate cell | Excel Discussion (Misc queries) | |||
Formating a cell to auto populate | Setting up and Configuration of Excel | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
Auto populate a cell | Excel Programming | |||
Auto Populate a cell | Excel Discussion (Misc queries) |