Increase and decrease the row height

[purplemx]

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.

 

[Bill Martin]

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

 

[Norman Jones]

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
'<<=============

 

[purplemx via OfficeKB.com]

Thanks.

Really works

it is what i was looking...

 

[purplemx via OfficeKB.com]

Yes

But i was needing something else...