Hi,

I have an Excel-sheet with a set of data, i.e. ;

Category     Name
Bitumen      John Doe
Cement       Josefina Doeline
......       ........
In PowerPoint I have a set of TextBoxes which I would like to populate with the data from the Excel-sheet.

I have found the VBA-code to populate the TextBoxes;
ActivePresentation.Slides(1).Shapes("Text Box #").TextFrame.TextRange.Text = "String"
However, what I still haven't figured out is to export the Bitumen/John Doe information from Excel via VBA and pars it into the "String" and populate the TextBox in PowerPoint.

All help is very appreciated.