Results 1 to 1 of 1

Thread: NEED HELP WRITING A CODE - Automatic bold formula with SpellNumber

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Exclamation NEED HELP WRITING A CODE - Automatic bold formula with SpellNumber

    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.
    Last edited by Aussiebear; 01-26-2025 at 08:17 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •