Prevent saving unless the data is filled
Hi,
I have a query regarding VBA
i have a range of data which consists of Loan number, Loan type, Lender name, Status, Reviewer Name, ID, date & timings
i want to create a vba code by which if the Loan number has been entered then all the fields adjacent to it has to be filled, if its not then vba will not allow to save the excel and pop up should show suggesting that all the fields has to be entered.workdir.xlsworkdir.xls
Put this code in the ThisWorkbook code module
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
hi AlphaFrog .You 'mist' a 'must' there!
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks