excel question

  broggs 10:37 17 May 08

hello..is there an easy way to display a tick symbolin excel?

is there a formula that could be inserted in the cells so that if the word tick is typed a tick will appear?

I know there is a symbol in the webdings font for a tick but would like a simpler way of doing this


  VoG II 10:47 17 May 08

Right click the sheet tab and select View Code. Copy and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If UCase(Target.Value) = "TICK" Then
With Target
.Font.Name = "Webdings"
.Value = "a"
End With
End If
Application.EnableEvents = True
End Sub

Close the code window using the X then type tick in a cell.

  broggs 11:02 17 May 08

thanks vog...works perfectly.

  broggs 17:02 18 May 08

works perfectly in exel 2007
will it work in office xp?

  VoG II 19:48 18 May 08

It will work in all versions 97 - 2007.

  broggs 19:33 09 Sep 08

thanks vog ..once again you are a star

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…