Multiple buttons

[Elenii]

Hi all,

I would like to have a table that when I click for example the A1 cell of this table it changes iis color and it displays the values from below the table to the right of the table.

 

[Belleke]

Does this help?,

 

[p45cal]

Two sheets in the attached, work slightly differently.

 

[Elenii]

Thank you very much for your answer!!! From your attachment I understand that the code works excalty as I would like to but I am very new to this and even though I put the code in the module of the excel I have created, when I go to Run it says I need to save a macro for it.

 

[Elenii]

Two sheets in the attached, work slightly differently.

Thank you very much for your answer!!! From your attachment I understand that the code works excalty as I would like to but I am very new to this and even though I put the code in the module of the excel I have created, when I go to Run it says I need to save a macro for it.

 

[Elenii]

Does this help?,

Thank you very much for your reply but since i am very new to this I cannot change the code a lot by myself and lists are more complicated than what i would like.

 

[Belleke]

In my example there are no macro's just formulas.

 

[Belleke]

Post your real example with some dummy names etc..........

 

[Elenii]

In my example there are no macro's just formul

Thank you for your reply! I don't want to have lists involved. This would be the actual excel file and Ineed to see which cell from the table is selected. Thank you !!!!

 

[Belleke]

Like I said post a real example, excel NOT A PICTURE

 

[p45cal]

even though I put the code in the module of the excel I have created, when I go to Run it says I need to save a macro for it.

Each sheet has its own code in its own sheet code-module (not a standard code-module).
There's nothing to run, each macro runs each time you make a change of selection on the sheet.

 

[Elenii]

Like I said post a real example, excel NOT A PICTURE

So, when I click the A1 cell of the table the values of cells F14:I14 should be copied to cells M4:M7 and the cell color should change in order to know which cell is selected ( i.e. A1 of the table). When any other cell other than the table' s cells is selected the cells M4:M7 will have no values. Ideally that is the idea. Thanks!!!!

 

[Elenii]

Each sheet has its own code in its own sheet code-module (not a standard code-module).
There's nothing to run, each macro runs each time you make a change of selection on the sheet.

Thank you very much!!!! I had to unblock the macros! Thanks!!!!