I am able to create a command button using VBA, but how can I go about using vba to set a assign that button to a subroutine?
As an example, I have an existing subroutine in module1. The new VBA code creates a button, but I want to have the code automatically set that button to execute the subroutine in module1.
Any ideas how this can be done?
Thanks!
As an example, I have an existing subroutine in module1. The new VBA code creates a button, but I want to have the code automatically set that button to execute the subroutine in module1.
Any ideas how this can be done?
Thanks!