Forum Discussion
Creating Excel Mandatory required Fields
I am creating a spreadsheet that the staff does not want to complete in full I have several columns that have mandatory fields, in C5, D5 and C17. When I create the VBA, When I press Alt - F11 I do n...
Yeah its still the same person... just with the 1125
ycanderson1125 If you right-click the menu and choose Customize Ribbon you can check the box next to "Developer". That will allow you to open the VBA editor using the left-most button on that tab:
- Yes butt I am having problems with the code for the requirement. I have tried an If formula but I it keeps coming up with an error.
- What error(s) are you getting please?
If you have any ideas on how i can make those cells required within the worksheet I can compare what may be missing in the code. I believe its in the verbiage of what I am asking for. I am requiring the team to date and initial in the cells as a sign off. If they do not then they cannot move forward. There has to be mm/dd/yy in several cells and their initials in the final cell as to sign off. Please review example attached.