Refer to Picture or Text Box in VBA

[Titian]

I have created text boxes containg standard company details like Name & Co Registration No & VAT No. Another text box with the Company address & Tel No etc.

Further I have a copy of the Company Logo - a picture - on my worksheet.

I want to transfer copies of these items onto invoices which I am creating, how do I refer to them? I know that the logo is a picure but where can I see what Picture No it is?

Any help much appreciated.

 

[Andrew Poulsom]

If you select it you can see it's name in the Name Box to the left of the Formula Bar. You can change its name there too by typing the new name and pressing Enter.

 

[Titian]

Thanks Anderew - how simple, and what a twitt I feel right now.

Kind regards