ActiveX HELP!!
 

I need to program a workbook around whether or not a single box is checked or
not.

Need help quick!

ActiveX HELP!!
 

Lori,

Several things,
first when are you checking if the workbox is checked? when the file is opened
if so do this in the workbook module

private sub workbook_open()
if sheet1.checkbox1.value = true then
'insert code
end if
end sub

where sheet1 is the sheet the checkbox is on and checkbox1 is the name of
the box you are checking. of course if you wish to check when the box itself
is checked then put this in the appropriate sheet module

private sub checkbox1_click() ' where checkbox1 is the name of the checkbox
if checkbox1.value = false then exit sub
'insert code here
end sub

"Lori~" wrote:

I need to program a workbook around whether or not a single box is checked or
not.

Need help quick!

ActiveX HELP!!
 

sorry i meant when were you checking if the checkbox is checked (my that's a
redunant statement)

"ben" wrote:

Lori,

Several things,
first when are you checking if the workbox is checked? when the file is opened
if so do this in the workbook module

private sub workbook_open()
if sheet1.checkbox1.value = true then
'insert code
end if
end sub

where sheet1 is the sheet the checkbox is on and checkbox1 is the name of
the box you are checking. of course if you wish to check when the box itself
is checked then put this in the appropriate sheet module

private sub checkbox1_click() ' where checkbox1 is the name of the checkbox
if checkbox1.value = false then exit sub
'insert code here
end sub

"Lori~" wrote:

I need to program a workbook around whether or not a single box is checked or
not.

Need help quick!

ActiveX HELP!!
 

Hey Ben,

Need to have this programmed so that when my single check box is checked
then certain cells within this workbook = a certain number for scoring
purposes on another sheet. So essentially when the box is checked things
need to happen...

Any ideas?

"ben" wrote:

Lori,

Several things,
first when are you checking if the workbox is checked? when the file is opened
if so do this in the workbook module

private sub workbook_open()
if sheet1.checkbox1.value = true then
'insert code
end if
end sub

where sheet1 is the sheet the checkbox is on and checkbox1 is the name of
the box you are checking. of course if you wish to check when the box itself
is checked then put this in the appropriate sheet module

private sub checkbox1_click() ' where checkbox1 is the name of the checkbox
if checkbox1.value = false then exit sub
'insert code here
end sub

"Lori~" wrote:

I need to program a workbook around whether or not a single box is checked or
not.

Need help quick!