Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a button in Macro
I am trying to create a button or check mark so that when a user presses it a
number will appear, but when they 'deselect' the button or check mark that number should become a 0 or a blank cell. I am very new to excel (as you can probably tell) so any help would be amazing. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a button in Macro
Double-click any cell to add check marks.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True If Not Intersect(Target, Range("A1:AZ100")) Is Nothing Then If Target = "P" Then Target = vbNullString ElseIf Target = vbNullString Then Target = "P" Else End If End If End Sub Formall text as Wingdings 2!! HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "rmann11" wrote: I am trying to create a button or check mark so that when a user presses it a number will appear, but when they 'deselect' the button or check mark that number should become a 0 or a blank cell. I am very new to excel (as you can probably tell) so any help would be amazing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a button in Macro | Excel Discussion (Misc queries) | |||
Creating a button to execute a macro | Excel Programming | |||
Creating macro button on toolbar | Excel Programming | |||
Creating a Macro Button to Extract Data | Excel Programming | |||
Creating a macro which presses a button containing a recorded macro | Excel Programming |