Transfer Data from Excel

excelnoob234

New Member
Joined
Apr 13, 2022
Messages
1
-1
I want to transfer data from one cell only from excel to powerpoint using VBA.My current code only gives me an empty rectangle shape but there is no numbers inside.

To further explain, I want to get the data from cell AC12 and then put this data as a statement on my powerpoint.

As I am still very new to VBA, I am unable to figure out how to proceed. I have attached my code below for your reference. Thank you.
 

Attachments

  • 1649834101934.png
    1649834101934.png
    34.6 KB · Views: 7

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Wouldn't it be sufficient that you copy AC12 form Excel and paste it as a link to Powerpoint? In this case PP will always show the updated value
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,170
Members
453,021
Latest member
Justyna P

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
Back
Top