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

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

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

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

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

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

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

Your Click event code can be shortened to this...

Private Sub CheckBox1_Click()
Columns("D").Hidden = CheckBox1.Value
End Sub

Rick


"Joel" <(E-Mail Removed)> wrote in message
news:FC65BE06-0D42-4BF7-B106-(E-Mail Removed)...
> 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