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 not get the automatic VBA it just gives me the number label for Alt keys. Secondly, I have tried several formulas given but I keep getting an error message can some please help. The goal is to have the team you the date and their initials in the field prior to printing, sharing or closing. Please help...

excel
Formulas and Functions
Macros and VBA
office 365

9 Replies

  • 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?
      • 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:

Resources