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.

"Jay worley" wrote:

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?
--
Thanks for posting a reply!