change command button colour when selected

Good Morning

I have several forms with multiple command buttons... all have different names however they all start with 'cmd'

Is there a way for a button to change colour when selected whilst changing the rest of the buttons on that form to their origional colour... I know how to do it, using this, when the buttons have numbers instead of names....

Many thanks for your help

Jim

Please Login or Register  to view this content.

see large yellow banner - how to upload your workbook - far easier then to give you a tailor made solution.

One way:

Please Login or Register  to view this content.

Or, you could add a Tag to all the Names buttons and check that. For example:

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.

Tag works much the same as caption but you could, for example, make the Name buttons tagged as Name and all the Number buttons tagged as Number. Then you can use the same loop structure.

This would probably be a more effective and less repetitive method of highlighting the selected command button(s).

Please Login or Register  to view this content.

You could use a class module to intercept the MouseDown and MouseUp conditions - with this method you do not have to intercept each Click event.