Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming a checkbox in Excel
Hello, I am very unfamiliar with programming VB and Macros in excel.
Here is the situation. I would like to have a check or an "X" appear in a cell when it is double clicked. Can someone please help me with that? Thank you! Lauren |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming a checkbox in Excel
right click on the sheet tab. Select View code. In the left dropdown at the
top of the module select Worksheet and on the right dropdown select BeforeDoubleclick. this will put in a code declaration for the Beforedoubleclick event. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) End Sub This event will fire whenever the sheet is double clicked, before the normal action of the double click is executed. The cancel argument allows you to cance that normal action. Now you need to add code to perform the function you want whenever the cell triggering the event (held as a reference in the target variable) is the cell you are interested in. For example for cell F9 to have this functionality Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _ Cancel As Boolean) If Target.Address = "$F$9" Then Cancel = True Target.Font.ColorIndex = 3 If Trim(LCase(Target.Value)) = "x" Then Target.ClearContents Else Target.Value = "X" End If End If End Sub Make sure you only have one BeforeDoubleClick event in your sheet module. -- Regards, Tom Ogilvy " wrote: Hello, I am very unfamiliar with programming VB and Macros in excel. Here is the situation. I would like to have a check or an "X" appear in a cell when it is double clicked. Can someone please help me with that? Thank you! Lauren |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
link a checkbox in a sheet to a checkbox on a userform? | Excel Programming | |||
How do I link one checkbox to update another checkbox? | Excel Programming | |||
checkbox on form reset from checkbox on sheet | Excel Programming | |||
programming checkbox properties | Excel Programming |