check marks in excel cells using your mouse

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to format an excel cell where a check mark will appear by
using a mouse click in that cell. I was thinking I saw this before, but
cannot remember how to do it.
 
You can do view>toolbars and select forms then click the check mark and hold
down alt and click in a cell

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
loco, you could also use some code to do it, like this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Will put a check mark in A1:A10 when you click in it
'change range to your range
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A1:A10")) Is Nothing Then
Target.Font.Name = "Marlett"
If Target = vbNullString Then
Target = "a"
Else
Target = vbNullString
End If
End If
End Sub


To put in this code right click on the worksheet tab and view code, in the
window that opens paste this code, press Alt and Q to close this window and
go back to your workbook. If you are using excel 2000 or newer you may have
to change the macro security settings to get the macro to run. To change the
security settings go to tools, macro, security, security level and set it to
medium

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Back
Top