Macro is part of excel itself…you can start that code from UiPath using invoke macro
And instead of input box you can use uipathvariable or can use UiPath input dialog to get the value
If you dont see developer tab in excel then go to more options → from ther in ribbons enable developer…you would see macros record there
Cheers