I’m fairly new to Excel macros. I have an Excel 2016 form that I’ve created for some data entry. I want to be able to run a PowerShell script when a particular cell is selected. My issue is I can run a PowerShell script but I can’t figure out how to pass 2 parameters to the PowerShell script in the macro. The parameters will come from two separate cells in the worksheet. I’ve been trying to use the Windows Script Hosts Exec method, as outlined here https://superuser.com/questions/724981/call-powershell-script-from-excel-macro but with no success. All I get is an empty Excel dialogue box
Is this a supported function or do I have to use an alternate method? I was hoping to use an Excel dialogue to return the result, but at the end of the day if I have to use PowerShell to return the result, fine; as long as I can pass it the parameters via the Excel cells.
Thanks
