| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
about check boxe
i am doing some calculations using Macros. I have problem with check boxes. I
want to link with some cells so that i can put my input parameters there for futher calculation. when i checked the box, link cells must appear and viceversa. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about check boxe
Check boxes have a property Linked cell where the links cell will havvew a
value True or False. You can set the lijnked cell either through the worksheet or VBA. To set the link cell on the worksheet you need to get into design mode and change the check box property. 1) view Menu - tool Bars - Control Tool box 2) On toolbar press triangle (Design Mode) 3) Press Property on tool bar (next to triangle). 4) Press Check box. On properrty window set LinkCell to a cell like A1. 5) Exit Design mode by pressing triangle again. Now when you check and uncheck the check box the linked cell will automatically change. "pmss" wrote: i am doing some calculations using Macros. I have problem with check boxes. I want to link with some cells so that i can put my input parameters there for futher calculation. when i checked the box, link cells must appear and viceversa. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about check boxes
Thanks
Actually i need to have some cells appear when i checked the box so that i can put my values in the appeared cell. "pmss" wrote: i am doing some calculations using Macros. I have problem with check boxes. I want to link with some cells so that i can put my input parameters there for futher calculation. when i checked the box, link cells must appear and viceversa. Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about check boxes
If you go into design mode and double click the check box it will create a
click macro. Put macro code into the click code to make the cells appear or disappear. "pmss" wrote: Thanks Actually i need to have some cells appear when i checked the box so that i can put my values in the appeared cell. "pmss" wrote: i am doing some calculations using Macros. I have problem with check boxes. I want to link with some cells so that i can put my input parameters there for futher calculation. when i checked the box, link cells must appear and viceversa. Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about check boxes
Can you please write me a micro code that will help me to do so. I am not
expert on using macros. "Joel" wrote: If you go into design mode and double click the check box it will create a click macro. Put macro code into the click code to make the cells appear or disappear. "pmss" wrote: Thanks Actually i need to have some cells appear when i checked the box so that i can put my values in the appeared cell. "pmss" wrote: i am doing some calculations using Macros. I have problem with check boxes. I want to link with some cells so that i can put my input parameters there for futher calculation. when i checked the box, link cells must appear and viceversa. Thanks |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about check boxes
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then Columns("D").Hidden = True Else Columns("D").Hidden = False End If End Sub "pmss" wrote: Can you please write me a micro code that will help me to do so. I am not expert on using macros. "Joel" wrote: If you go into design mode and double click the check box it will create a click macro. Put macro code into the click code to make the cells appear or disappear. "pmss" wrote: Thanks Actually i need to have some cells appear when i checked the box so that i can put my values in the appeared cell. "pmss" wrote: i am doing some calculations using Macros. I have problem with check boxes. I want to link with some cells so that i can put my input parameters there for futher calculation. when i checked the box, link cells must appear and viceversa. Thanks |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about check boxes
thanks
"Joel" wrote: Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Columns("D").Hidden = True Else Columns("D").Hidden = False End If End Sub "pmss" wrote: Can you please write me a micro code that will help me to do so. I am not expert on using macros. "Joel" wrote: If you go into design mode and double click the check box it will create a click macro. Put macro code into the click code to make the cells appear or disappear. "pmss" wrote: Thanks Actually i need to have some cells appear when i checked the box so that i can put my values in the appeared cell. "pmss" wrote: i am doing some calculations using Macros. I have problem with check boxes. I want to link with some cells so that i can put my input parameters there for futher calculation. when i checked the box, link cells must appear and viceversa. Thanks |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about check boxes
Your Click event code can be shortened to this...
Private Sub CheckBox1_Click() Columns("D").Hidden = CheckBox1.Value End Sub Rick "Joel" wrote in message ... Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Columns("D").Hidden = True Else Columns("D").Hidden = False End If End Sub "pmss" wrote: Can you please write me a micro code that will help me to do so. I am not expert on using macros. "Joel" wrote: If you go into design mode and double click the check box it will create a click macro. Put macro code into the click code to make the cells appear or disappear. "pmss" wrote: Thanks Actually i need to have some cells appear when i checked the box so that i can put my values in the appeared cell. "pmss" wrote: i am doing some calculations using Macros. I have problem with check boxes. I want to link with some cells so that i can put my input parameters there for futher calculation. when i checked the box, link cells must appear and viceversa. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to make a validation that makes one box equalsum of other boxe | Excel Discussion (Misc queries) | |||
| Loop through column(s) to check values, perform action based on check | Excel Programming | |||
| Check boxe size | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Dialogue Boxe | Excel Programming | |||
Linear Mode
