Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Check Box Macro for multiple sheets
Hello, I am trying to write a macro (complete newbie) has the following
function: (I used the toolbar, not forms for checkboxes) if the value ot checkbox 1 on sheet 1 = true, then a value of 10 should enter into cell C33 on sheet 2. Any suggestions for the newbie? Thanks ahead of time |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Check Box Macro for multiple sheets
Don't use a macro.
Right click on that checkbox. Choose properties. Assign the LinkedCell to an out of the way cell Then use that out of the way cell in your formula. Put this: =if(sheet1!a1=true,10,"it's not checked!") in C33 of sheet2 I used A1 of sheet1 for my out of the way cell. Kbernbr wrote: Hello, I am trying to write a macro (complete newbie) has the following function: (I used the toolbar, not forms for checkboxes) if the value ot checkbox 1 on sheet 1 = true, then a value of 10 should enter into cell C33 on sheet 2. Any suggestions for the newbie? Thanks ahead of time -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compiling data from multiple Excel sheets - macro? | Excel Worksheet Functions | |||
Macro to Filter Information in Multiple sheets and Make graph | Excel Worksheet Functions | |||
Macro to protect multiple sheets? | Excel Worksheet Functions | |||
macro to compile columns on multiple sheets | Excel Discussion (Misc queries) | |||
creating macro working across multiple sheets | Excel Worksheet Functions |