Hello friends, aaj iss post me hum janenge ki microsoft excel me hyperlink image macro ka use kaise karte hai. Microsoft excel me kisi website ya online page se koi contents copy karne par kuch images bhi paste ho jati hai. Aur excel spreadsheet me inn images se link extract karne ke liye excel vba command ka use karte hai.
Aapne website ya online kisi page me kai images dekhi hogi. Jinpar click karte hai to ek new website open ho jati hai. Kyuki inn images me web address link hota hai inhi link ki vajah se image par click karne par new webpage open hota hai.
Aapne websites me email envelope bhi dekhe honge jinpar click karne par email box open hota hai. Excel worksheet me paste email envelope or other web image se link ko kaise extract karte hai aaiye janate hai.
Microsoft Excel Me Hyperlink Image Macro Ka Use Kaise Kare
- Macro Record Aur Macro Ka Use Kaise Kare
- Hyperlink Text Macro Ka Use Kaise Kare
- Data Validation List Kaise Use Kare
Step 1
Sabse pehle inn images ko website se copy kar excel worksheet me paste kare.
- Remove Numeric Macro Ka Use Kaise Kare
- Ms Excel Home Tab Ki Puri Jaankari
- Ms Excel Insert Tab Ki Puri Jaankari
Step 2
Excel worksheet me hyperlink image paste hone ke baad Alt+F8 key press kare. Ya upar excel tab me view > macros > view macros par click kare.
- Macro name set kare, kuch bhi name set kar sakte hai.
- Create button par click kare.
- Excel Formula Me Symbol Add Kaise Kare
- Data Advance Filter Ka Use Kaise Kare
- Excel Worksheet Me Hyperlink Ka Use Kaise Kare
Step 3
Ab vba command paste karne ke liye jo micro box open hoga isme niche di gayi command paste kare.
Sub GetHyperlinks()
Dim NextRow As Long
Dim Shp As ObjectNextRow = 1
For Each Shp In ActiveSheet.Shapes
If Shp.Type = msoPicture Then
Cells(NextRow, “E”) = Shp.Hyperlink.Address
NextRow = NextRow + 1
End If
Next ShpEnd Sub
- Vba command paste kare.
- Play button par click kare.
Ab wapas excel worksheet me jaye, yahapar aap dekh sakte hai ki images me jo link hai. Vo excel worksheet me extract ho gaye hai niche image me dekhe.
Issi tarah se aap hyperlink image macro ka use kar kuch hi seconds me microsoft excel me paste. Kisi bhi hyperlink image se link extract kar sakte hai. Chahe vo excel worksheet me websites se copy ki hui image ho ya email envelope.
I hope aapko hyperlink image macro se related ye jaankari helpful lagi hogi. Excel worksheet me hyperlink image macro ki ye jaankari aapko kaisi lagi comment karke apna feedback jarur de. Aur agar ye post pasand aayi hoto isse share karna na bhule.