I created a user form with a command button for a user form to popup and input data onto a certain worksheet in the same workbook. Worksheet are labeled by year. I was wanting the user form to pop up when selected submit the data on currently sheet 2022 column "C" and currently row 1112. I am entering multiple locates from email and would just like to use a user form and submit data instead of having to use tab. The user form will not pop-up and not sure I used the correct dropdown box at the top to select worksheet year. If anyone knows why the user form command button isn't work any help or advice is appreciated, hoping I got the mini-sheet pasted correctly.
locate log.xltm | |||
---|---|---|---|
C | |||
1112 | |||
2022 |