Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This works by double-clicking in a cell, and toggles the check-mark.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Const WS_RANGE As String = "H1:H10" '<=== change to suit On Error GoTo err_handler Application.EnableEvents = False If Not Application.Intersect(Target, Range(WS_RANGE)) Is Nothing Then With Target .Font.Name = "Marlett" Select Case .Value Case "": .Value = "a" Case "a": .Value = "" End Select End With Cancel = True End If err_handler: Application.EnableEvents = True 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 (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lasocki" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I enter a tick sign in a spreadsheet cell somehow? | Excel Discussion (Misc queries) | |||
how can i enter a tick on an excel spreadsheet | Excel Discussion (Misc queries) | |||
Tick Boxes | Excel Worksheet Functions | |||
Copying Tick Boxes | Excel Worksheet Functions | |||
How can I put a tick/check mark in an Excel spreadsheet? | Excel Discussion (Misc queries) |