Adding a comment to Conditional Formatting via VBA

[ctbanker]

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...

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>

 

[cooper645]

no, i'm afraid we are now beyond my knowledge. I hope you get it sorted, if there is anything else then let me know