Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom checkbox
I have a large (10 page) worksheet that is mostly cells to select YES, NO,
N/A, SAT, UNSAT. How can I: 1. Resize the built in excel checkbox or radio buttons? or 2. Have an "X" or large custom check mark placed in the correct cell with a mouse click? or 3. Another way to simply filling out this sheet? I have Excel97, VBA, and Excel 2000. Thanks Hank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom checkbox
1 - You can't change the size of these objects.
2 - You can use the Worksheet_SelectionChange event to place an X in a cell. 3 - see # 2 Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Assume you want only one cell from A1 to A5 to be X'd at any time. This will ensure only the cells you want to deal with are handled here, and place an X in the selected cell. If Target.Column = 1 And Target.Row <= 5 And Target.Cells.Count = 1 Then 'Clear all 5 cells, then set just the one cell to X Range("A1:A5").Value = "" Target.Value = "X" End If End Sub -----Original Message----- I have a large (10 page) worksheet that is mostly cells to select YES, NO, N/A, SAT, UNSAT. How can I: 1. Resize the built in excel checkbox or radio buttons? or 2. Have an "X" or large custom check mark placed in the correct cell with a mouse click? or 3. Another way to simply filling out this sheet? I have Excel97, VBA, and Excel 2000. Thanks Hank . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
2003 - 2007 custom macro and custom button restore. | Excel Discussion (Misc queries) | |||
Adding custom list and text boxes to the custom tool bar from Excel C API | Excel Discussion (Misc queries) | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel |