Re: about check boxes

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

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

Rick


"Joel" <Joel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FC65BE06-0D42-4BF7-B106-B87C20A5F910@xxxxxxxxxxxxxxxx
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

.

Relevant Pages

  • Re: edit multiple formulas
    ... and cells with values, but don't include any cells with formulas that shouldn't ... Sub testme01() ... Set myRng = Nothing ... Debra Dalgleish has some notes how to implement macros here: ...
    (microsoft.public.excel)
  • Re: Excel 2007 files running very slow
    ... For your CF you could use macros to paint the cells as desired. ... ) Is Nothing Then Exit Sub ... in order to mass sort and paste the info back to the original sheet, ...
    (microsoft.public.excel)
  • Delete All Blank Rows--A plea for help
    ... figure out why none of the 3 macros I have to delete blank rows is not ... Some cells are text, some are numbers, and I've set ... Sub RemoveBlankRows() ... On Error GoTo 0 ...
    (microsoft.public.excel.programming)
  • Re: Paste Special
    ... Do I need to select one of my cells to do so? ... Sub Macro2() ... If you don't know anything about macros - do a google search for "Excel ...
    (microsoft.public.excel.misc)
  • Re: How to capture Max cell value (High Water Mark)
    ... Where A1 is the cell that is changing and the HiWater function can be in any ... I don't have any other macros in the workbook. ... Sub Test_Enable_Events ... I'm only using it on the same worksheet where the macro was created. ...
    (microsoft.public.excel)