MS Excel I-card Macro Project-15 Video

MS Excel I-card Macro Project-15 Video

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

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. To Getting This Paid Course You have to Visit VedantSri Store by Going to the Link Below.

Read News Today : https://varanasidailynews.com/

Leant in MS Excel: https://youtu.be/4Y63MuEsMO4

Learnt bill remainder in MS Excel: https://youtu.be/ViP3_65P84s

MS Excel form with database macro project: https://youtu.be/tgFn7dWGIRQ

MS Word cover page design: https://youtu.be/zbkXeGNW23U

MS Excel basic calculator basic project: https://youtu.be/ELZ9MDKU3e4

MS word 3D design project: https://youtu.be/JTgFRIMnfKU

MS Word certificate project: https://youtu.be/NyqBEU5nTxA

Important links:

VedantSri official website: https://vedantsri.com

Course store website: https://vedantsri.in

Job assist website: https://www.jobdo.in

MS Word class: https://mswordclass.com/ 

Corel free class: https://corelclass.com/ 

Free Excel class: https://msexcel.com/