Hello,

I have the following table in Excel:
A B C D
17 Amount Name

In the cell ("C17") I want to have the following formula ="text"&B17&" "&A17&" "&A17
  • With the B17 in BOLD
  • With the Second A17 in BOLD
  • And with the First A17 with my VBAProject.Module4.SPELLNUMBER() module applied to it


Furthermore, it would be great if this VBA macro would run automatically when the value in ("A17") and/or ("B17") change.


Can someone help me write this; as I am very new to VBA and have been trying to write this code with threads from other people.