Place VBA in cell on spreadsheet
 

I want tp place a Userform_checkbox in cell B3 - B8. I then want to use the
true/false return from each box to place info from cells E3 - E8 in cells G3
- G8.

I am VERY new at this and will take the advice to buy an Excel Bible by John
Walkenbach.

Thanks for your help.

Slimjater

Place VBA in cell on spreadsheet
 

Use a checkbox from the Forms Toolbar.

You can rightclick the checkbox and set the Linked cell to whatever needs to
hold the True/False.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"slimjater" wrote:

I want tp place a Userform_checkbox in cell B3 - B8. I then want to use the
true/false return from each box to place info from cells E3 - E8 in cells G3
- G8.

I am VERY new at this and will take the advice to buy an Excel Bible by John
Walkenbach.

Thanks for your help.

Slimjater

Place VBA in cell on spreadsheet
 

I'm not even that up-to-speed yet. Thanks for the reply but can you give me
code. I now have the book.

Thanks,

slimjater



"slimjater" wrote:

I want tp place a Userform_checkbox in cell B3 - B8. I then want to use the
true/false return from each box to place info from cells E3 - E8 in cells G3
- G8.

I am VERY new at this and will take the advice to buy an Excel Bible by John
Walkenbach.

Thanks for your help.

Slimjater

Place VBA in cell on spreadsheet
 

You don't need code for that.

It's showing the Forms Toolbar, clicking the checkbox icon on it, and
placing it on the sheet.

Rightclick the checkbox, choose Format Control... Control fill in the
cell link.

Repeat as many times as needed.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"slimjater" wrote:

I'm not even that up-to-speed yet. Thanks for the reply but can you give me
code. I now have the book.

Thanks,

slimjater



"slimjater" wrote:

I want tp place a Userform_checkbox in cell B3 - B8. I then want to use the
true/false return from each box to place info from cells E3 - E8 in cells G3
- G8.

I am VERY new at this and will take the advice to buy an Excel Bible by John
Walkenbach.

Thanks for your help.

Slimjater