Hello all,
The subject might sound pretty simple to some experts but I am just a beginner at coding and wanted some help here. Let me try to explain the issue as clearly as possible.
1. There is a sheet with some cells which are to be filled up by the user and then a button (called the "SAVE" button) is given which saves the filled-up data to a different sheet in the same workbook and resets the fields.
2. There is a cell (F5) where a drop-down gives the user an option to select a value out of 4 options.
3. If the user selects the value "Others" in F5, he needs to give some details in cell G5 and it CANNOT be left blank and the user gets a popup saying "You need to enter a description if you have selected "Others"".
4. If the user selects any other option in F5, he can leave cell G5 blank.
5. Only if these conditions are fulfilled, the save and reset codes will run, otherwise not.
I wrote some code after searching a lot on Google but could not find something which works for me. Can you guys help me out, please? Thank you.
The subject might sound pretty simple to some experts but I am just a beginner at coding and wanted some help here. Let me try to explain the issue as clearly as possible.
1. There is a sheet with some cells which are to be filled up by the user and then a button (called the "SAVE" button) is given which saves the filled-up data to a different sheet in the same workbook and resets the fields.
2. There is a cell (F5) where a drop-down gives the user an option to select a value out of 4 options.
3. If the user selects the value "Others" in F5, he needs to give some details in cell G5 and it CANNOT be left blank and the user gets a popup saying "You need to enter a description if you have selected "Others"".
4. If the user selects any other option in F5, he can leave cell G5 blank.
5. Only if these conditions are fulfilled, the save and reset codes will run, otherwise not.
I wrote some code after searching a lot on Google but could not find something which works for me. Can you guys help me out, please? Thank you.