Hormazabal
07-05-2019, 09:30 AM
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.
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.