With some help of some of the members of this site the Excel tool attached to this posting is almost ready I need assistance with the last bit.
The tool basically compares two sets of data and creates a report showing the changes between “Prior Data” and the “Current Data”. To run the report the user pushes the “Process Changes” button on the top right corner of the “Data” worksheet. The report is created on the worksheet “Changes”.
The part I need help with is after the “Changes” worksheet is created I want to – as much as is practical – force the user to supply “justification” for the changes shown on the “Changes” worksheet. I hope to accomplish this by having a dialog box pop-up for the user to enter text for their justification. I would like this pop-up dialog to appear once for every row appearing on the “Changes” worksheet (excluding the top two header rows). I’ve never worked with pop-up dialog boxes before and don’t really know how to approach a solution.
Finally I would like the text the user enters (not more than 50 characters) into the pop-up dialog box to appear in column P on the Changes worksheet.
Any help would be much appreciated.