| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| place data from 1 spreadsheet to another | Excel Discussion (Misc queries) | |||
| how do I place the sheet tab name in my spreadsheet by formula? | Excel Worksheet Functions | |||
| Why does my excel spreadsheet show ### in place of a sum? | Excel Discussion (Misc queries) | |||
| Look up values and place in spreadsheet | Excel Discussion (Misc queries) | |||
| How do I move the end of the spreadsheet place where (ctrl + end). | Excel Discussion (Misc queries) | |||
Linear Mode
