Hi there! i would like to know if its possible to get image from comment and add it to userform?
at this moment i have added image to comment and user form, but now i have to get that image to other form. is it possible at all?
or is there any other way to get picture to sheets cell and later at any time that same picture to other userform picturebox
if misunderstood, ask whats needed
thanks
at this moment i have added image to comment and user form, but now i have to get that image to other form. is it possible at all?
Private Sub CommandButton1_Click()
Dim Pict
Dim ImgFileFormat As String
Dim cmt As Comment
Range("a1").Comment.Delete
Set cmt = Range("a1").AddComment
cmt.Text Text:=""
ImgFileFormat = "Image Files (*.jpg),others, png (*.png),*.png"
Pict = Application.GetOpenFilename(ImgFileFormat)
If Pict = False Then End
UserForm1.Image1.Picture = LoadPicture(Pict)
Image1.PictureSizeMode = fmPictureSizeModeStretch
With cmt.Shape
.Fill.UserPicture Pict
End With
End Sub
or is there any other way to get picture to sheets cell and later at any time that same picture to other userform picturebox
if misunderstood, ask whats needed
thanks