Hey guys,
I am not sure if this is entirely possible, but what I am trying to do is to take a live screenshot of a certain particular cells (e.g Cell A1 ) and to insert the captured shot into the userform so that any changes made to the cell made through the user form is reflected accordingly in the picture inside the user form.
For example,
I have a user form textbox that is linked to a cell,
And I write this in the userform
(e.g Range("A1")=Me.txtbox1
When I insert a value into the textbox that is linked to the cell, I should be able to see the changes on my userform picture ,which essentially would be the captured screenshot using the camera feature.
The reason I would require this is to capture a screenshot of my matrix models built on excel cells so that users would be able to view the changes on the positioning as they input the parameters into the form.
Bookmarks