Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get a field in excel to auto complete with a check mark
I have a check list in excel and wish to use check marks to siginify
completion of individual fields. How do I get excel to insert a checkmark into a field when I double click that field? |
#2
|
|||
|
|||
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean) With Target If .Value = "a" Then .Value = "" Else .Value = "a" End If .Font.Name = "Marlett" End With End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips "RichardZ" wrote in message ... I have a check list in excel and wish to use check marks to siginify completion of individual fields. How do I get excel to insert a checkmark into a field when I double click that field? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I disable the auto hyperlink feature in Excel? | Excel Discussion (Misc queries) | |||
How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) | |||
Can you enable auto complete from a custom list in Excel? | Excel Discussion (Misc queries) | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) |