This line of code is in your form (updated from what you posted initially):
But you have not specified in the code which worksheet you want to look at. Therefore it defaults to the currently active worksheet, which is "Main Menu". You need to explicitly say which worksheet you want. (If the code were in a worksheet module, the reference would default to that worksheet instead of the active one.)
I also think you want that to be +1, not 2, unless you want to leave a blank line after each new customer.
I don't know what your assignment requires, but you may want to consider validation of the input data. For example, zip code should be 5 digits but I can enter FOOBAR without any problem.
Note to other members who may wonder why I'm answering this: We have a rule against doing homework for people but in this case the OP has made a good effort to solve the overall problem and is asking specific, focused VBA questions.
Bookmarks