MarkMueller
New Member
- Joined
- Aug 16, 2018
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
HI, I have the following solution to come up with:
I have a worksheet that needs to check for Column F having an entry of Yes or No, if it is Yes then auto-populate Column J with a 1, If it is a No then auto-populate Column J with a 0.
I probably need to go through the Pseudocode first, sorry.
The workbook has multi columns filled in and there are two that require an action of which is defined above. However, the complexity is based on unlocking the workbook first, then the user goes through the entry process defined as:
Enter Yes or No in Column F (multiple entries within the column with different sections), if the drop down answer is "Yes" then auto change column J with a 1, if the answer is "No" then auto change column J with a 0.
For each section, I want to have a pop-up displayed that asks the user if they are completed, the response is Yes or No;
If Yes then re-lock active_worksheet, save the workbook, then exit. If they are not completed then return to active-cell.
Simply:
the workbook is opened
the user selects the correct worksheet
the active_worksheet is unlocked in columns F and G
then the user enters Yes or No in column F
Column J is auto-updated with 1 or 0 depending on entry
at end of the section, a pop-up is presented to ask if completed or not
if answer to pop-up is No then continue at Active_cell
if answer to pop-up is Yes then relock active_worksheet, save sheet, then exit
I hope that someone can assist, I have spent two days trying to determine the solution, as I am not that good at VBS (Macros) it is difficult.
Thank you for your assistance.
I have a worksheet that needs to check for Column F having an entry of Yes or No, if it is Yes then auto-populate Column J with a 1, If it is a No then auto-populate Column J with a 0.
I probably need to go through the Pseudocode first, sorry.
The workbook has multi columns filled in and there are two that require an action of which is defined above. However, the complexity is based on unlocking the workbook first, then the user goes through the entry process defined as:
Enter Yes or No in Column F (multiple entries within the column with different sections), if the drop down answer is "Yes" then auto change column J with a 1, if the answer is "No" then auto change column J with a 0.
For each section, I want to have a pop-up displayed that asks the user if they are completed, the response is Yes or No;
If Yes then re-lock active_worksheet, save the workbook, then exit. If they are not completed then return to active-cell.
Simply:
the workbook is opened
the user selects the correct worksheet
the active_worksheet is unlocked in columns F and G
then the user enters Yes or No in column F
Column J is auto-updated with 1 or 0 depending on entry
at end of the section, a pop-up is presented to ask if completed or not
if answer to pop-up is No then continue at Active_cell
if answer to pop-up is Yes then relock active_worksheet, save sheet, then exit
I hope that someone can assist, I have spent two days trying to determine the solution, as I am not that good at VBS (Macros) it is difficult.
Thank you for your assistance.