![]() |
making check boxes
how do i make check boxes
-- |
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 -- |
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 -- |
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 -- |
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 -- |
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 -- |
All times are GMT +1. The time now is 07:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com