Excel Macro Help

MarkMueller

New Member
Joined
Aug 16, 2018
Messages
23
Office Version
  1. 365
Platform
  1. 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.

 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,240
Messages
6,170,951
Members
452,368
Latest member
jayp2104

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top