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?

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)


"Katie" wrote in message
ups.com...
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?

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

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)


"Katie" wrote in message
oups.com...
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

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?

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


"Katie" wrote in message
ups.com...
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?