Dear Forum,
I think I got the partial solution myself but still need to be absolutely sure of its usability..
The other thing which I still need is to HIDE the Columns after finishing Data Entry in the appropriate columns like in the Columns of the 4 Payments which happen to be the last column of the respective mode..The Entire column needs to be hidden after the Enter KEY is pressed..
Please find the code which I tried for HIDING/UN-HIDING COLUMNS...
I have just tried this but it works but if needs any improvisation please feel free to add as I am not good in VBA to really get it...
And importantly, please advise on HIDING the Specific Columns which are opened on the
Change event after the information is entered..in the Columns such as
Column X ------Cheque Payment
Column Z ------Cash Payment
Column AD ------RTGS/NEFT Payment
Column AH ------Credit Card Payment
On entering the Information in these Columns I want the Complete Range of Columns to be HIDDEN..
Warm regards
e4excel
Bookmarks