| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
making check boxes
how do i make check boxes
-- |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
making check boxes
Format the font of a cell as Marlett, then enter a in the cell
-- Gary''s Student - gsnu200770 "bkunes" wrote: how do i make check boxes -- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
making check boxes
macro
-- "Gary''s Student" wrote: Format the font of a cell as Marlett, then enter a in the cell -- Gary''s Student - gsnu200770 "bkunes" wrote: how do i make check boxes -- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
making check boxes
Right from the Recorder:
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 2/27/2008 by James Ravenswood ' ' Application.CommandBars("Forms").Visible = True ActiveSheet.CheckBoxes.Add(98.25, 124.5, 24, 23.25).Select Range("F7").Select End Sub -- Gary''s Student - gsnu200770 "bkunes" wrote: macro -- "Gary''s Student" wrote: Format the font of a cell as Marlett, then enter a in the cell -- Gary''s Student - gsnu200770 "bkunes" wrote: how do i make check boxes -- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
making check boxes
i decided to go with an if statement displaying the check mark u first
described, if true. however, i have a problem, how do i write a logic statement to match SC508-0001-67.81 and SC508-0001-*? SC508-0001-*?=SC508-0001-67.81 doesnt work how do i make this work -- "bkunes" wrote: how do i make check boxes -- |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
making check boxes
--i decided to go with an if statement displaying the check mark u first
described, if true. however, i have a problem, how do i write a logic statement to match SC508-0001-67.81 and SC508-0001-*? SC508-0001-*?=SC508-0001-67.81 doesnt work how do i make this work "Gary''s Student" wrote: Right from the Recorder: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 2/27/2008 by James Ravenswood ' ' Application.CommandBars("Forms").Visible = True ActiveSheet.CheckBoxes.Add(98.25, 124.5, 24, 23.25).Select Range("F7").Select End Sub -- Gary''s Student - gsnu200770 "bkunes" wrote: macro -- "Gary''s Student" wrote: Format the font of a cell as Marlett, then enter a in the cell -- Gary''s Student - gsnu200770 "bkunes" wrote: how do i make check boxes -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a Formula Contingent on Check Boxes | Excel Worksheet Functions | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
| Do you have instructions for making check boxes? | Excel Worksheet Functions | |||
| Do you have instructions for making check boxes? | Excel Worksheet Functions | |||
Linear Mode
