Broken VBA? (Or just me being clueless...You decide)

SecFire

New Member
Joined
Nov 19, 2020
Messages
7
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Hi. I have been working on a spreadsheet that should help us improve both productivity, and speed to help us stay afloat during the covid slowdown.
My initial spreadsheet worked beautifully, in that column A would change colors to indicate a new project status with each phase of the project being completed
by entering a date in the next column.

In order to make it a little more user friendly, I also added a user form for data entry, which is also working thanks to the some great help.... however,
when using the userform for data entry, the project progress/color changing is now not working. Could anyone please take a look and tell me what I am doing
wrong that has caused one code to work and the other not to work?

Link To File (Google Drive)
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,883
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
Your change event is looking at row 6 for the colours, rather than row3
 

Watch MrExcel Video

Forum statistics

Threads
1,130,181
Messages
5,640,640
Members
417,159
Latest member
Mayozero

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
Top