excel question

  broggs 10:37 17 May 2008

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 2008

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 2008

thanks vog...works perfectly.

  broggs 17:02 18 May 2008

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

  VoG II 19:48 18 May 2008

It will work in all versions 97 - 2007.

  broggs 19:33 09 Sep 2008

thanks vog ..once again you are a star

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?