+ Reply to Thread
Results 1 to 1 of 1

Insert character and specify font, based on font at cursor location

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    547

    Insert character and specify font, based on font at cursor location

    I have a macro which takes the selected cells, puts them in a form, and has the ability to insert the character "#" at the cursor location.
    This works but I need an additional functionality: The font of the inserted character "#" should be based on the font at the cursor location. See table below. For example, if the font at the cursor location is Forte, the inserted character font is Monotype Corsiva.
    At the moment, the font of the newly inserted character is the same as the previous character.


    TABLE
    Please Login or Register  to view this content.
    MODULE CODE
    Please Login or Register  to view this content.
    FORM CODE
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA : Change font colour within a cell up to nth character
    By mowens74 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2017, 04:35 PM
  2. Refer .font.name, .font.size, line.dashstyle to a cell instead of hard coding.
    By avarshav in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2016, 11:50 AM
  3. Changing font colour based on a character
    By pjzapped in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 03-27-2016, 07:02 AM
  4. Show all font options of a single character
    By mackensteff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2012, 09:36 PM
  5. Change font color based on font color of another cell
    By Ibyers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 09:36 AM
  6. Change font color based on character count
    By frendz in forum Excel General
    Replies: 10
    Last Post: 04-20-2012, 06:02 AM
  7. Excel Font question: Can you overscore a character?
    By DrJoe in forum Excel General
    Replies: 1
    Last Post: 03-30-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1