Command Button to Update cell date based on color.

snownut2

New Member
Joined
Sep 22, 2011
Messages
18
I have a workbook with 2 sheets, a data sheet "Data" and a calculations sheet "Calcs". Looking to add a command button on "Calcs" sheet. When button is activated the macro finds all rows on "Data" sheet that are "Yellow" and updates range of cells in column x with the current date. At the same time the data from cells a1, b1,c1 (on "calcs" sheet) is copied to cells f1, g1,h1. (x & a1... & f1... are just examples not actual cell id's. And finally once command button has been activeted and run I want to deactivate the command button so it cannot be used again if there is data or value is number 0 in cells f1,g1,h1. The command button will be in cell f8.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,215,703
Messages
6,126,314
Members
449,308
Latest member
Ronaldj

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top