Command Button

[TBM]

Greetings ,

I was hoping to simplify the macro that I am using, as I have over 50 buttons that I use. It is rather time consuming every time I have to add a new product.

Below I have attached the code.

Ideally if a command button could simply be placed within a cell, where by, the adjacent cell would be affected. If this something like this would work it would save a lot of time writing macros.

Any help would be appreciated.

I am currently using this code for a command button.

Please Login or Register  to view this content.

As well as this one

Please Login or Register  to view this content.

Terrance

[Norie]

Terrance

If you used buttons from the Forms toolbar you could assign the same macro to all of them.

Within the macro you could use Application.Caller to identify which button was clicked to trigger the macro and from that, via the TopLeftCell property, get the relevant range to apply the macro to.

[TBM]

Thank you for your reply

Maybe I am not understanding, that seems similar to what I have already been doing.

I was hoping for two command buttons that adds an integer and one that subtracts.
whereby, I can populate the entire sheet with as many as 50 plus buttons using those same two buttons.

Ideally those buttons by the nature of their location would operate the adjacent cell.

Is there command buttons that can do this? It something similar?