Toggle Button

Hi all,

I am looking a putting a VB command button on one of my sheets, which when pressed once it does one thing, then when pressed again it does something different.

e.g. when pressed first time it hides a range of rows, when pressed again it unhides them.

Hope you can help

Dave

Good morning Dave_2k5

Why not set up a check box from the control toolbox toolbar. Once you've drawn it on screen double click on it and paste the code below into the window that opens. Close the window to return to Excel and on the Control Toolbox bar select Design Mode (top left) to set the checkbox.

The code shown assumes that your checkbox will be called Checkbox1 and that you want to hide rows 10 to 15 inclusive.

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Rows("10:15").EntireRow.Hidden = True
Else
Rows("10:15").EntireRow.Hidden = False
End If
End Sub

HTH

DominicB

I would do that......But want it to be a button not a checkbox!!

Cheers Anyway

Dave

Hi Dave

If it HAS to be a button then have a look in the control toolbox - there is a toggle button. Don't use the forms toolbar because there isn't one there.

HTH

DominicB

Hi Dave

Range("F12:F46").EntireRow.Hidden = _
Not Range("F12:F46").EntireRow.Hidden

--


XL2003
Regards

William
[email protected]


"Dave_2k5" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> I am looking a putting a VB command button on one of my sheets, which
> when pressed once it does one thing, then when pressed again it does
> something different.
>
> e.g. when pressed first time it hides a range of rows, when pressed
> again it unhides them.
>
> Hope you can help
>
> Dave
>
>
> --
> Dave_2k5
> ------------------------------------------------------------------------
> Dave_2k5's Profile:
> http://www.excelforum.com/member.php...o&userid=19667
> View this thread: http://www.excelforum.com/showthread...hreadid=401061
>