Checkbox macro  
Author Message
woodsman





PostPosted: Fri Aug 05 09:06:14 CDT 2005 Top

Excel Programming >> Checkbox macro

Hi, I am trying to create a macro on an excel document for an option to
check a box. I have a macro created and stored in word for the same
function. Is there a way I can import that macro from word to excel or
do I need to re-create it? If I do need to re-create it, is VBA the
easiest way to do this?

Excel201  
 
 
Bob





PostPosted: Fri Aug 05 09:06:14 CDT 2005 Top

Excel Programming >> Checkbox macro Hi Katie,

Probably need new code as you will want to do something different (Excel and
Word are different :-)).

What exactly do you want to do with the checkbox. With linking to a cell,
you might be able to get away without VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)




> Hi, I am trying to create a macro on an excel document for an option to
> check a box. I have a macro created and stored in word for the same
> function. Is there a way I can import that macro from word to excel or
> do I need to re-create it? If I do need to re-create it, is VBA the
> easiest way to do this?
>


 
 
Katie





PostPosted: Fri Aug 05 09:14:14 CDT 2005 Top

Excel Programming >> Checkbox macro Basically, I have copied a tax return form on to an excel sheet for
future use. I have empty boxes next to different entries to be checked
at a later time. So I want the boxes to remain empty for the time being
but allow for checks to be added later

 
 
Bob





PostPosted: Fri Aug 05 09:35:50 CDT 2005 Top

Excel Programming >> Checkbox macro You can copy a checkbox from the forms toolbar onto the worksheet and then
link that checkbox to a cell (right-click the checkbox, select Format
Control, then the Control tab, and put your linked cell reference in the
cell link box). You can then test this linked cell for a value of TRUE to
calculate accordingly.

--

HTH

RP
(remove nothere from the email address if mailing direct)




> Basically, I have copied a tax return form on to an excel sheet for
> future use. I have empty boxes next to different entries to be checked
> at a later time. So I want the boxes to remain empty for the time being
> but allow for checks to be added later
>


 
 
Katie





PostPosted: Fri Aug 05 10:14:36 CDT 2005 Top

Excel Programming >> Checkbox macro Thank you. Now if I have four seperate checkbox options in the same
cell..i think this creates a problem. I believe each checkbox
(including data) needs to have its own cell, is that right? is there
anyway to go back and divide the cell?

 
 
Bob





PostPosted: Fri Aug 05 10:53:45 CDT 2005 Top

Excel Programming >> Checkbox macro No Katie, don't try to complicate it. One linked cell per checkbox. It is
nice and simple, and it is no great overhead. Remember the old adage ...
KISS <vbg>

Bob




> Thank you. Now if I have four seperate checkbox options in the same
> cell..i think this creates a problem. I believe each checkbox
> (including data) needs to have its own cell, is that right? is there
> anyway to go back and divide the cell?
>