Creating multiple check boxes macro

I would like to be able to create multiple check boxes that will accomplish 2 things.

1. When Checked will display a date in the cell one column to the right.
2. When checked will change colors

Secondly, since i will need to make several hundred of these I would like a macro that will allow me to define how the check box is to behave and then have a macro which will allow me to define all of the settings and then input the number of check boxes that I want and it will create that many boxes.

I recall seeing a macro on here some time ago (at least 1 month prior but no more than 6 months prior) which allowed you to type into a form how many check boxes or option boxes you wanted to create in your workbook, and then it would create that many.

I have searched the forum some and do not seem to be able to find this post now. Any thoughts on how I can find that post, or have another macro of your own that would accomplish the same thing.

The colors I would like to use are white if empty green if checked. The date is determined by the checkbox

If I understand your post correctly you are suggesting that i eliminate the check box entirely, and just find a way that allows the cell to input a date and change colors when i click on it.

Is my understanding correct?

If that is your suggestion I like the idea if you can explain to me how i can make that happen

Attached you will find an example file. As parts are made they go through each work center (Listed across the top). I would like to be able to click on the cell and have it change colors and input a date. I really don't care if it is a check box

I got what you posted to work. I have discovered one potential problem which you may be able to help me solve. I would like to require a double click to "empty" the cell.

You are being so tremendously helpful. I greatly appreciate it. Thank you.

However, when I double click on the range it does not "empty" the cell. It does nothing at all as far as I can tell. Is there a way to tweak the code so that if i double click on a cell it will return to its original status?

lets make it double click on column c

Wow! You are good. THANK YOU THANK YOU! If you are out of patients I will stop now, but I have tweaked this file a little bit more to see about getting some new features.

I do notice one little glitch (And that may be because I added a couple of columns to the left, but I thought that I modified the code to accommodate the changes) If there is an empty cell to the left the double click feature does not seem to work properly.

I also have a little formatting issue in one of the columns that I have added I am pretty sure it is because I am trying to get a date and a word to display in the same column I am not sure if you can do that exactly, but I know that excel will allow something like that because you can have a cell that says Saturday Nov. 7.

Also, a little help on the conditional formatting would be greatly appreciated as well.

Thank you in advance.

The function of the double click and the display of the date and color seems to work. What about the other two questions the formatting of the date in the column labeled Production Status, and the conditional formatting. Is there any way to make those things happen?

That works beautifully! Thank you! How about that one little glitch where you cannot double click on the lower yellow cell and have the date and shading show up to the right (It seems like that is because it wont work if any cells are empty to the left. I need to be able for it to work with empty cells as that is something that occurs frequently.

Working perfectly!

Thank You so much.