Magnifying The Selected Cell With Macro

October 19, 2016 Leave a comment

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
With Selection
.Name = “Zoom_Cells”
With .ShapeRange
.ScaleWidth Zoom_In, msoFalse, msoScaleFromTopLeft
.ScaleHeight Zoom_In, msoFalse, msoScaleFromTopLeft
With .Fill
.ForeColor.SchemeColor = 44
.Visible = msoTrue
.Transparency = 0
End With
End With
End With”

Download Template

Excel Vba Column Hiding-Unhiding With Horizontal Form

October 17, 2016 Leave a comment

         In the previous tutorial, we were finding the last used column according to the first row of columns. The used code that to find last used column :

“lst_column = ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column”

Any value in the first row may not always be . Values may be in bottom rows. For this reason, we created the following code to find last used column in this template :

“lst_column = ActiveSheet.UsedRange.Columns(ActiveSheet.UsedRange.Columns.Count).Column”

excel column hide unhide

Download Example File