This is in a Excel 365 Userform...
I have a command button (ADD) that looks at my customer's record number (TBrecord.value). If there isn't a number it assigns one, otherwise it edits the existing record.
The second page of my userform contains a picture insert. I'm wanting to change this picture to a jpg image of a call tree diagram. These images are stored in a folder titled Images and are named with the customer's record number 001, 002, 003 etc. (TBrecord.value).
I am trying to come up with a macro that I can add inside of my sub that will use the customer's record number (TBrecord.value) and insert it inside of the image's address when this sub is used.
CallTree.Picture = Load Picture ("Y:\CCX Applications\") & ("TBrecord.jpg")
Thanks in advance. I appreciate any help.