Quote Originally Posted by Ivan F Moala
Why do you have 40 commandbuttons performing the same function ?
Only ask as it maybe easier if you just designed the need for 40 out rather then look for an easier method of call the same procedure?
Perhaps the macro performs a different op depending on the button caller?
Only reason I could think of... But even so, I'd probably opt for a listbox then.