Combining two codes into one

Hello,

I am a beginner at Excel VBA, so sorry for stupid questions... I am still learning

I have two different codes. They each work correctly, but I want to combine them into one, to do a bit different task.

This code creates Buttons "Green", and when you press it, it opens window with information, on which row that button is.

Please Login or Register  to view this content.

Second code is for changing color of the row. I assign it to the button. And then row color changes to green or back to normal, by the push of that button.

Please Login or Register  to view this content.

The problem is, that I need button for every row. And I have around 1000 rows...
So, could you please help me to combine these two codes into one?
I need that every row would have a button, and that row color could be changed by pressing that button. Also, from the first code, I dont need tat it would pop up a window with row number information.


Thanks in advance

Hi and welcome to the forum. Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Since this is your first post I'll add the code tags for you but please remember for the future.)

However do you really need to add button shapes for each row just to colour a particular row? Wouldn't a sheet double click event be simpler? The double click event could be a 'toggle' which either added or removed the green colour.

Originally Posted by Aqmas

This green color is just half of the story.

Hi,

We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of of other stuff which is important but hasn't been mentioned!

It's still not at all clear to me why you actually need 4 buttons on each row.
Can we go back to basics.
If as you say the colours of the cells on the rows depend on the status of the cells in the row why not use conditional formats to paint the cells and avoid the need for buttons at all?

If there is some over-riding reason to have buttons, why not just have four buttons at the top and code them so that they use the active cell row when they are clicked to paint the cells. Better still why have buttons at all when you could (as I said before) use the sheet double click event and detect which of the four columns is being double clicked?