Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I automatically put X in a cell just by clicking that cell?
In Excel, I want to have a spreadsheet where users can check-mark cells, just
by clicking that cell...not actually having to type an X in it. Is this possible and if so, how? |
#2
|
|||
|
|||
jjakel, you can with some code, put in worksheet code, right click on the
worksheet tab a view code, paste this in, will put an X in column A when you click in it, will also remove it if you click it again Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Count 1 Then Exit Sub If Target.Column = 1 Then If Len(Trim(Target.Value)) = 0 Then Target.Value = "X" Else Target.ClearContents End If End If End Sub You could also make it put in a check mark like this Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Count 1 Then Exit Sub If Target.Column = 1 Then If Len(Trim(Target.Value)) = 0 Then Target.Value = Chr(252) Target.Font.Name = "Wingdings" Target.Font.Size = 10 Else Target.ClearContents End If End If End Sub -- 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 "jjakel" wrote in message ... In Excel, I want to have a spreadsheet where users can check-mark cells, just by clicking that cell...not actually having to type an X in it. Is this possible and if so, how? |
#3
|
|||
|
|||
Why not use checkboxes from the Control Toolbox toolbar. Then link the
check box to a cell. Just a thought. Paul "jjakel" wrote in message ... In Excel, I want to have a spreadsheet where users can check-mark cells, just by clicking that cell...not actually having to type an X in it. Is this possible and if so, how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
display multiple lines of text within a merged cell automatically | Excel Worksheet Functions | |||
copy combobox - cell link to change automatically | Excel Worksheet Functions | |||
Edit cell automatically takes you to cell | Excel Worksheet Functions | |||
How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions |