Рет қаралды 47
How to insert multiple pictures into selected cells in Microsoft Excel | MS Excel Bangla Tutorial
This video about How to insert multiple pictures into selected cells in Microsoft Excel | MS Excel Bangla Tutorial.
For getting more video please stay with us & also SUBSCRIBE my channel.
So I hope you learn something form this video and if you have any questions, feel free to ask me in comments below, till then good bye, take care.
#msexcel
#excel_tutorial
#insertpicture
******Getting Picture code*******
Sub InsertPictures()
Dim PicList() As Variant
Dim PicFormat As String
Dim Rng As Range
Dim sShape As Shape
On Error Resume Next
PicList = Application.GetOpenFilename(PicFormat, MultiSelect:=True)
xColIndex = Application.ActiveCell.Column
If IsArray(PicList) Then
xRowIndex = Application.ActiveCell.Row
For lLoop = LBound(PicList) To UBound(PicList)
Set Rng = Cells(xRowIndex, xColIndex)
Set sShape = ActiveSheet.Shapes.AddPicture(PicList(lLoop), msoFalse, msoCTrue, Rng.Left, Rng.Top, Rng.Width, Rng.Height)
xRowIndex = xRowIndex + 1
Next
End If
End Sub
***************
Related Tags:
How to insert multiple pictures into selected cells in Microsoft Excel,Insert Picture in-cell in Excel,Excel Insert Picture Into Cell | Multiple Pictures,
Bulk Insert Images into Excel Cells! One step to fill multiple,Insert multiple pictures at once,How to insert multiple pictures and resize them at once,
Insert Image in Excel Cell (and Lookup Images),How to insert pictures into cells in Excel,How to insert multiple pictures into Excel cells,#msexcel,#msexcel_tutorial