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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks