Run a VBA function from a button passing paramters

Run a VBA function from a button passing paramters

hello.

I have a VBA function (or Macro or whatever you call it) and it takes 3 parameters (int, int, bool)
I want to call this function from several differnet buttons but with differnent parameter values.
Is this possible?
The closest I've got to doing this is creating 'dummy' functions eg funcNameWith1and2andTrue that in turn calls the function with the correct params. This is of course horrible, so is there a correct way of doing it?
cheers,
mat

This is a migrated post! Originally posted on 24.09.2008 by user matholton. Please be aware that information can be outdated.