ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   making check boxes (https://www.excelbanter.com/excel-worksheet-functions/178031-making-check-boxes.html)

bkunes

making check boxes
 
how do i make check boxes
--


Gary''s Student

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
--


bkunes

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
--


Gary''s Student

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
--


bkunes

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
--


bkunes

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