I'm trying to create a VBA program/a macro that monitors a color being filled to a row (entire row) and opening a form in VBA that asks for two times (picked up and delivered), a date delivered, and a textbox with person delivered to, and 2 optional checkboxes then take those values answered in the form and insert them into a note on the selected row.
Not sure if I'm asking for too much just not very familiar with this but would make a project I'm working on very easy.
EDIT:
I have already created the form. If the color is yellow, I don't want the form to pop up only for red / green
Not sure if I'm asking for too much just not very familiar with this but would make a project I'm working on very easy.
EDIT:
I have already created the form. If the color is yellow, I don't want the form to pop up only for red / green