scale based on a cell!!

miyat

Board Regular
Joined
Nov 27, 2009
Messages
166
hi, i have a square drawn on four different lines to form a square... i want that that square will be interactive. the width and the height of the cell will scale base on the value i put in cell A1 and A2.. is it possible?
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
For a square using cells c5:d6

Private Sub Worksheet_Change(ByVal Target As Range)
Dim side1 As Long
Dim side2 As Long

If Target.Column = 1 And Target.Row < 3 Then
side1 = Range("a1").Value / 2
side2 = Range("a2").Value / 2
Columns("C:d").ColumnWidth = side1
Rows("5:6").RowHeight = side2
End If
End Sub
 

miyat

Board Regular
Joined
Nov 27, 2009
Messages
166
hi steve, tnx for the reply... i am a beginner in vba programing... i cant actually understand that.. can u tell me that in details?tnx..
 

miyat

Board Regular
Joined
Nov 27, 2009
Messages
166
steve, it doesnt work.. should i paste it on a module or this workbook?
 

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
Right-click on the sheet tab, then select the view code option.

Change the dropdown options to worksheet and change.

Paste the code between the sub/end sub lines
 

Watch MrExcel Video

Forum statistics

Threads
1,123,271
Messages
5,600,651
Members
414,399
Latest member
Ninjee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top