Chewyhairball
Active Member
- Joined
- Nov 30, 2017
- Messages
- 312
- Office Version
- 365
- Platform
- Windows
Hi
I have used the macro recorder to add a picture to a textbox which works. It will run from a button.
However i would like it to allow me to chose the picture file as opposed to it being hard coded into the VBA.
I have tried to integrate Application.getopenfilename into the code but i cant figure it out.
any help would be appreciated
thanks
I have used the macro recorder to add a picture to a textbox which works. It will run from a button.
However i would like it to allow me to chose the picture file as opposed to it being hard coded into the VBA.
I have tried to integrate Application.getopenfilename into the code but i cant figure it out.
any help would be appreciated
thanks
VBA Code:
ActiveSheet.Shapes.Range(Array("TextBox 4")).Select
With Selection.ShapeRange.Fill
.Visible = msoTrue
.UserPicture "H:\.My Work\Personal Stuff\signature.jpg"
.TextureTile = msoFalse
.RotateWithObject = msoTrue
End With