Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage Increase/Decrease | Excel Discussion (Misc queries) | |||
increase/decrease decimal | Excel Worksheet Functions | |||
% of increase or decrease | Excel Discussion (Misc queries) | |||
How do I set a cell that can increase but never decrease? | Excel Discussion (Misc queries) | |||
Value Increase/Decrease/No Change | Excel Worksheet Functions |