Hi all,

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

 Range = Application.InputBox(Prompt:="Select range", Type:=8)
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:

 Range = Excel.Application.InputBox(Prompt:="Select range", Type:=8)
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!