Place VBA in cell on spreadsheet

S

slimjater

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
 
W

Wigi

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.
 
S

slimjater

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
 
W

Wigi

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top