Forum Discussion

ycanderson's avatar
ycanderson
Copper Contributor
Dec 09, 2021

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...
excel
Formulas and Functions
Macros and VBA
office 365
JKPieterse's avatar
JKPieterse
Silver Contributor
Dec 10, 2021
What kind of machine are you using? Windows, Mac, other?
What Excel application are you using, Excel desktop or on-line?
ycanderson1125's avatar
ycanderson1125
Copper Contributor
Dec 10, 2021
Yeah its still the same person... just with the 1125
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Dec 10, 2021

    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:

    • ycanderson1125's avatar
      ycanderson1125
      Copper Contributor
      Dec 10, 2021
      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.
      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Dec 10, 2021
        What error(s) are you getting please?

Resources