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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
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
"loco" <[email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks