Transfer Data from Excel

E

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 is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

T
  • Question Question
VBA to update Powerpoint Text from Excel Data in Cells
Replies
9
Views
975
tbakbradley
T
D
  • Question Question
Can PowerPoint update an Excel cell (not looking for excel to update PowerPoint)
Replies
4
Views
184
didi1983ON
D
H
  • Question Question
Copy Tables & Charts from Excel to Powerpoint, Keep source formatting and change position
Replies
0
Views
310
h899
H
Y
  • Question Question
VBA Code to activate the tab and and transfer data
Replies
1
Views
240
Joe4
Joe4
C
  • Question Question
Embedding and displaying a Powepoint slide presentation in an Excel Userform. Possible?
Replies
0
Views
334
chazrab
C

Forum statistics

Threads
1,223,888
Messages
6,175,203
Members
452,617
Latest member
Narendra Babu D

Share this page

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