Macro to concatenate or add text to cell value based on another cells value

OK, here's the desired outcome:

In column "H", if "Note" is slected from a drop down list, the corresponding note description in column "F" will add an asterisk and a space before the text description

For example,:

"Note" is selected, and the text in column "F", "Customer to verify" would change to "* Customer to verify".

Thanks

I was able to figure this one out except for undoing the asterisk if the drop down value changes from a "Note" to another value. How can I remove the asterisk and the space before the description? Thanks

Please Login or Register  to view this content.

Perhaps the TRIM function would be a solution to the above post. Any ideas of what code would search the beginning of the active cell for an "* " and then TRIM(ActiveCell) or something to this effect? If no "* ", then ActiveCell value. Thanks