Home > Excel Tutorial > Magnifying The Selected Cell With Macro

Magnifying The Selected Cell With Macro

For to magnify the cell’s view the following solution can be applied :
– The font size of selected cell can be changed with macro.

– This macro that added to the worksheet module, looks at the currently selected cell and increases its font size.
” Zoom_In = 1.75″

– Later the value of the cell is displayed on the shape.
“sel.CopyPicture Appearance:=xlScreen, Format:=xlPicture ‘Create zoom picture
ActiveSheet.Pictures.Paste.Select
With Selection
.Name = “Zoom_Cells”
With .ShapeRange
.ScaleWidth Zoom_In, msoFalse, msoScaleFromTopLeft
.ScaleHeight Zoom_In, msoFalse, msoScaleFromTopLeft
With .Fill
.ForeColor.SchemeColor = 44
.Visible = msoTrue
.Solid
.Transparency = 0
End With
End With
End With”

Download Template

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: