Passing parameters from clicking a button

[Jay worley]

I have two worksheets in a workbook. I would like to pass a file name
parameter into a create file subroutine. Is there a way to pass a parameter
in a subroutine when clicking on a button in each worksheet?

 

[Joel]

You probably have a click function when the button is pressed. Add an Input
box into this function to get the desired input. The input box could select
a cell containing the required data.