Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro + IF Function?
Hi,
I'm extremely new to using macro's in excel. I haven't been able to do more than recording one and simply editing it in the vb editor. What i want is this. I have on sheet 1 six check boxes. What i want the macro to do is this. Checkbox 1 is checked I want cell D66:D80 to become something i define (which i guess i could record in excel). If it's unchecked this has to be gone. When i check checkbox 2 it does exactly the same. So far it's not a big problem. However, now i want to check 2 (or 3) boxes. For example. Checkbox 1 checked - D66:D80 become my values Checkbox 2 checked - It first checks if D66:d80 is empty, if it is. It puts it's info on D66:D80, if it is not empty it puts the info in F66:F80. (Checkbox 3 checked - It first checks if D66:d80 is empty, then if F66:F80 is empty, then it puts it at the closest possible empty range) Idem Dito for Checkbox 3,4,5,6. It will have to handle a maximum of 4 checked checkboxes. Any idea on how to do this? Thanks for any effort put into this. Greetz, Gunti |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro + IF Function?
I have another question for anyone interested in helping.
How can i use the checkbox to use a different macro when it's checked or unchecked? In this example: i want to delete the info when it's being unchecked. And add the info to d66:d80 when it is checked. Greetz, Gunti "Gunti" wrote: Hi, I'm extremely new to using macro's in excel. I haven't been able to do more than recording one and simply editing it in the vb editor. What i want is this. I have on sheet 1 six check boxes. What i want the macro to do is this. Checkbox 1 is checked I want cell D66:D80 to become something i define (which i guess i could record in excel). If it's unchecked this has to be gone. When i check checkbox 2 it does exactly the same. So far it's not a big problem. However, now i want to check 2 (or 3) boxes. For example. Checkbox 1 checked - D66:D80 become my values Checkbox 2 checked - It first checks if D66:d80 is empty, if it is. It puts it's info on D66:D80, if it is not empty it puts the info in F66:F80. (Checkbox 3 checked - It first checks if D66:d80 is empty, then if F66:F80 is empty, then it puts it at the closest possible empty range) Idem Dito for Checkbox 3,4,5,6. It will have to handle a maximum of 4 checked checkboxes. Any idea on how to do this? Thanks for any effort put into this. Greetz, Gunti |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a Function or Macro for This? | Excel Discussion (Misc queries) | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
Function or macro? | Excel Worksheet Functions | |||
Do I need a macro or just a function? | Excel Worksheet Functions | |||
How Do I (Macro Function)? | Excel Worksheet Functions |