Inputbox to retrieve Excel range from Powerpoint VBA

Hi all,

I'm familiar with how to use Inputbox to retrieve a user-selected range in Excel VBA:

Please Login or Register  to view this content.

However, I'm having trouble doing the same in Powerpoint VBA. The following code creates an inputbox window, but selecting an open instance of excel does not do anything--nothing is populated in the inputbox:

Please Login or Register  to view this content.

Does anyone know how to fix this?

On a minor note, for some reason the Powerpoint code leads to the inputbox being opened in the background instead of foreground. Maybe something to do with the excel.application command?

Thanks in advance!

Please upload a workbook with a clear explanation in the sheets itself by highlighting the cells, rows or columns where you want to get the help for with a remark if needed.

Regards

To clarify, I'm not looking to use the inputbox from Excel. Instead, I'm looking to use the inputbox from a powerpoint macro, but allow the user to select an excel range from the inputbox. These are not about specific cells/rows/columns.