Refer to Picture or Text Box in VBA

Titian

Well-known Member
Joined
Dec 17, 2004
Messages
567
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.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

Well-known Member
Joined
Dec 17, 2004
Messages
567
Thanks Anderew - how simple, and what a twitt I feel right now.

Kind regards
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,305
Messages
5,836,534
Members
430,437
Latest member
Emilycr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top