Hi All,
I'm very new to the VBA world and don't have much experience with coding. I want to do the following, but am not sure how to:
I have a column called "Classification", and if there is any text (example "Fee" or "Due Diligence") in a cell, I want a comment ("please fill either choose Loan Proceeds or Prepaid Deposit") to pop-up at the corresponding cell under "Paid From". I have Conditional Formatting set-up to make the cell red when the corresponding "Classification" cell is occupied, but that doesn't clearly state what I need done (and isn't as cool either).
Any help would be greatly appreciated! Please refer to a sample worksheet below...
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
I'm very new to the VBA world and don't have much experience with coding. I want to do the following, but am not sure how to:
I have a column called "Classification", and if there is any text (example "Fee" or "Due Diligence") in a cell, I want a comment ("please fill either choose Loan Proceeds or Prepaid Deposit") to pop-up at the corresponding cell under "Paid From". I have Conditional Formatting set-up to make the cell red when the corresponding "Classification" cell is occupied, but that doesn't clearly state what I need done (and isn't as cool either).
Any help would be greatly appreciated! Please refer to a sample worksheet below...
Fees Breakdown | ||||
Classification | Paid From: | Item | Disposition | Amount |
Fee | Loan Proceeds | SBA Guarantee Fee | Bank Controlled Account | 94,256.50 |
Due Diligence | Prepaid Deposit | Appraisal | General Ledger Account | 12,000.00 |
Fee | Loan Proceeds | UCC Search / Filing Fee | Bank Controlled Account | 120.00 |
Due Diligence | Prepaid Deposit | Environmental | General Ledger Account | 3,900.00 |
Fee | Loan Proceeds | SBA Loan Packaging Fee | Bank Controlled Account | 2,500.00 |
Fee | Prepaid Deposit | Flood Determination Fee | Bank Controlled Account | 67.50 |
Fee | Loan Proceeds | Loan Closing Fee | Customer Refund | 6,569.00 |
Fee | COMMENT HERE | 499.75 | ||
Total | 119,912.75 |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>