Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click a cell next to an item and have a checkmark appear
I have a list of items. I would like to click the cell to the left of the
item and have a checkmark appear, click the cell again and have the checkmark disappear. Is this possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click a cell next to an item and have a checkmark appear
Hi JP
This should sort you out. Highlight the column you plan to click on and format that column as Wingdings. Paste this code in the worksheet module where you want the event to occur, so Sheet1 for example. I have made it a doubleclick event so it will appear and disappear as you DOUBLE click on the cell. Take care Marcus Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) On Error Resume Next If Intersect(Target, Range("F2:F6")).Value = "ü" Then Target.Value = "" Else: Target.Value = "ü" End If End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click a cell next to an item and have a checkmark appear
You are 'The Man'! Thanks, Marcus, have a Happy New Year.
"marcus" wrote: Hi JP This should sort you out. Highlight the column you plan to click on and format that column as Wingdings. Paste this code in the worksheet module where you want the event to occur, so Sheet1 for example. I have made it a doubleclick event so it will appear and disappear as you DOUBLE click on the cell. Take care Marcus Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) On Error Resume Next If Intersect(Target, Range("F2:F6")).Value = "ü" Then Target.Value = "" Else: Target.Value = "ü" End If End Sub . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double click item in Listbox to select item and close Listbox | Excel Programming | |||
Upon mouse click a checkmark appears in a square. | Excel Programming | |||
Move cell info from one worksheet to another buy click a checkmark | Excel Programming | |||
Checkmark on Menu Item | Excel Programming | |||
Placing checkmark beside menu item | Excel Programming |