(Last Updated On: December 22, 2021)

MS Excel I-Card Macro Project-15 Video

Contents show

Set Photo Button Module VBA Coding

Public Sub SetPhoto()
On Error GoTo NOT_SHAPE
Dim PicWtoHRatio As Single
Dim CellWtoHRatio As Single
With Selection
PicWtoHRatio = .Width / .Height
End With
With Selection. TopLeftCell
CellWtoHRatio = .Width / .Height
End With
Select Case PicWtoHRatio / CellWtoHRatio
Case Is > 1
With Selection
.Width = .TopLeftCell.Width
.Height = .Width / PicWtoHRatio
End With
Case Else
With Selection
.Height = .TopLeftCell.RowHeight
.Width = .Height * PicWtoHRatio
End With
End Select
With Selection
.Top = .TopLeftCell.Top
.Left = .TopLeftCell.Left
End With
Exit Sub
NOT_SHAPE:
MsgBox"Select a Picture before Clicking on this Button."
End Sub

Designed I-Card Sample

Watch Excel Project Related Video Link Below

Video For Excel Data Entry Userform 2021: Excel UserForm Buttons Macros Project-1

Video For Excel Data Entry Userform 2021: Excel Userform Buttons Macros Project-2

Video For Excel Macros Search & Print: Excel Macros Search & Print Project

Video for Student Excel Entry Form: Excel Students Entry Form Macros Project-1

Video for Student Excel Entry Form: Excel Student Entry Form Macros Project-2

Video for Data Transfer in Excel: Excel Transfer Data Macros Project

Important Link:-Digital Marketing Course Fees, Duration, Syllabus, Scope, Institute, and Jobs in Varanasi

Install Free App For CCC Class Google Play Store

If you want to learn CCC Online Class Free in 2021 with Latest Neilit Syllabus Updates then here is good news for you. Because you are going to get completely free opportunity to Learn CCC Course Training By VedantSri. You have to Get only VedantSri Free App Called EasyTarika Available on Google Play Store. By Simple searching EasyTarika on Google PlayStore, You will Get this EasyTarika App. Only Install Then log in by Simple Entering Mobile number or Gmail Id or Facebook Id then you will get your CCC Class with Latest Syllabus Based Course Training. You can visit EasyTarika App Link on Google PlayStore Simply by Clicking the Below Link. (Excel I-card Macro Project)

Important Link:-ADCA Course Fees, Duration, Scope, Syllabus, Admission, Institutes & Jobs in Varanasi

Buy Rs 199/- CCC Online Class

If you plan to buy a CCC Class to Learn Online at Home then VedantSri Also Provides a Very Low-cost CCC Online Class with CCC’s Latest Updated Syllabus here. You will Get this Online Class only by Paying Just Rs. 199/-. You Can Pay Through UPI, Debit or Credit Card, or Net Banking Payment option. For Getting This Paid Course You have to Visit VedantSri Store by Going to the Link Below.