Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating macro in Excel that can add a check mark
There is a Macro found in Word (see fax sheet template) that will create a
check mark in a box if you double click on the box. Does anyone know how translate this macro into Excel? I am using Word 97 SR-2 (behind the times a bit....) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating macro in Excel that can add a check mark
Why not just use a checkbox from the forms toolbar?
marina1072 wrote: There is a Macro found in Word (see fax sheet template) that will create a check mark in a box if you double click on the box. Does anyone know how translate this macro into Excel? I am using Word 97 SR-2 (behind the times a bit....) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating macro in Excel that can add a check mark
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean) Const WS_RANGE As String = "H1:H10" On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target If .Value = "a" Then .Value = "" Else .Value = "a" .Font.Name = "Marlett" End If End With End If ws_exit: 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 Phillips (replace somewhere in email address with gmail if mailing direct) "marina1072" wrote in message ... There is a Macro found in Word (see fax sheet template) that will create a check mark in a box if you double click on the box. Does anyone know how translate this macro into Excel? I am using Word 97 SR-2 (behind the times a bit....) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
How do I get a check mark into an excel documents | Excel Discussion (Misc queries) | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
How do you create a check mark in Excel? | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel |