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.

Increase and decrease the row height
 

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

Increase and decrease the row height
 

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.

Increase and decrease the row height
 

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

Increase and decrease the row height
 

Yes

But i was needing something else...

--
purplemx

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