vba to take screenshot of a shape with text boxes linked to cell values

[spgexcel]

Hello there,
I am again here to ask for a peculiar query.
I have following table in my excel. Using loop vba I pull the values in row 3.
The cells in row 3 are linked with the text boxes in the shape under tag "Main Tab".
I am looking for a poosibility of a vba code where with each iteration in loop there will be a screenshot of that particular output and be pasted in the excel sheet one below other or besides is also fine.
does not need to be linked image it can also be a hard pasted image like a snip from snipping tool.
I tried recording macro but ddi not work. Other ways also failed for me.
I have pasted examples of images that I am talking about.
Is it possible to do in excel? If yes, guidance would help

Thanks in advance
Sumant

 

[spgexcel]

So here is a code that I worked upon with little success.

Sub new_def2()

Dim dtime As Double
dtime = Timer

Dim i As Long

With Sheets("Sheet2")


    For i = 1 To .Range("B1").Value
    .Range("B3").Value = (i - 1) + 1

Call screenshot

Next i
Application.CutCopyMode = False

Debug.Print "Time is: " & (Timer - dtime)


End With
    
End Sub

Sub screenshot()

Dim pic_rng As Range
Dim sh_paste As Worksheet
Dim ch_paste As Chart
Dim PicTemp As Picture

Application.ScreenUpdating = False

Set pic_rng = Worksheets("Sheet2").Range("A11:E21")
Set sh_paste = Worksheets("Sheet2")

Charts.Add

ActiveChart.Location Where:=xlLocationAsObject, Name:=sh_paste.Name

Set ch_paste = ActiveChart
pic_rng.CopyPicture Appearance:=xlScreen, Format:=xlPicture

ch_paste.Paste

Application.DisplayAlerts = True

Application.ScreenUpdating = True

'MsgBox ("Range is Saved as Image")

End Sub

I get a badly sized screenshot.

Hello there,
I am again here to ask for a peculiar query.
I have following table in my excel. Using loop vba I pull the values in row 3.
The cells in row 3 are linked with the text boxes in the shape under tag "Main Tab".
I am looking for a poosibility of a vba code where with each iteration in loop there will be a screenshot of that particular output and be pasted in the excel sheet one below other or besides is also fine.
does not need to be linked image it can also be a hard pasted image like a snip from snipping tool.
I tried recording macro but ddi not work. Other ways also failed for me.
I have pasted examples of images that I am talking about.
Is it possible to do in excel? If yes, guidance would help

Thanks in advance
Sumant

View attachment 64907