Increase and decrease the row height

Hi

i have a file and i try to find a macro to increase the height of the row
with a button
and also other one to decrease the height.

On every single must to increase the height 5 by 5 size.

I hope is clear my question...

Any one can help me.

purplemx wrote:
> Hi
>
> i have a file and i try to find a macro to increase the height of the row
> with a button
> and also other one to decrease the height.
>
> On every single must to increase the height 5 by 5 size.
>
> I hope is clear my question...
>
> Any one can help me.

-------------

Have you tried to record a macro while you do what you want manually, then go in
and look at the VBA created by the macro recorder?

Bill

Hi Purplemx.

Try:

'=============>>
Private Sub CommandButton1_Click()
With ActiveCell
..RowHeight = .RowHeight + 5
End With
End Sub
'<<=============


'=============>>
Private Sub CommandButton2_Click()
With ActiveCell
..RowHeight = .RowHeight - 5
End With
End Sub
'<<=============


---
Regards,
Norman



"purplemx" <u18108@uwe> wrote in message news:5af16d8a1ad84@uwe...
> Hi
>
> i have a file and i try to find a macro to increase the height of the row
> with a button
> and also other one to decrease the height.
>
> On every single must to increase the height 5 by 5 size.
>
> I hope is clear my question...
>
> Any one can help me.

Thanks.

Really works

it is what i was looking...

--
purplemx

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1

Yes

But i was needing something else...

--
purplemx

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1