|
|
|
Author |
Message |
woodsman
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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?
>
|
|
|
|
|
|
|