Sure you can, define your procedure to have parameters. Suppose you following VBA procedure in Access, defined in a code module named "testmodule" ...

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.