| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Create a check box for each row
I am trying to create an issues list in excel, and I want to add a check box
in the field as the issue is resolved. |
|
#2
|
|||
|
|||
|
Hi Nicholas,
Install by rightclick on sheettab then view code then insert the following: Private Sub Worksheet_BeforeDoubleClick(ByVal _ Target As Range, Cancel As Boolean) If Target.row = 1 Then Exit Sub 'row 1 s/b column titles If Target.Column < 2 Then Exit Sub If UCase(Target.Value) = "P" Then Target.Value = "" Else Target.Value = "P" End If End Sub Format the entire column with Symbol Font then fix the first row formatting for normal (probably Arial) usage so you can see column headings. If you don't like the style of the tick mark then see http://www.mvps.org/dmcritchie/rexx/...bols.htm#ticks More information on Event macros http://www.mvps.org/dmcritchie/excel/event.htm A doubleclick event is a much more positive action than merely activating a cell. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Nicholas" wrote in message ... I am trying to create an issues list in excel, and I want to add a check box in the field as the issue is resolved. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a small box I can place a check mark in? | Excel Discussion (Misc queries) | |||
| create a housekeeping check sheet on excel | New Users to Excel | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| Can you create a check box or radio button in Excel? | Excel Discussion (Misc queries) | |||
| Creating a check box that does not require security clearance. | Excel Worksheet Functions | |||
Linear Mode
