+ Reply to Thread
Results 1 to 3 of 3

TextBox in UserForm to mirror format of active cell

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

    TextBox in UserForm to mirror format of active cell

    This user-form has a text box which shows the string in a selected cell (using ActiveCell.Formula). The form then allows the fonts of each character to be manipulated by clicking buttons.
    It works as intended, the font is changed within the worksheet.
    Is it possible to show the font change within the TextBox of the UserForm?

    Form snapshot.png

    USERFORM
    Please Login or Register  to view this content.
    MODULE
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: TextBox in UserForm to mirror format of active cell

    A textbox can only display one font.
    If posting code please use code tags, see here.

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

    Re: TextBox in UserForm to mirror format of active cell

    OK thanks. It looks like it's far too difficult. To support rich text (this is the correct term I guess) I read mentions of additional reference/s and InkEdit. This is probably too advanced for this purpose.
    Thanks anyway.

+ 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. [SOLVED] Excel 2010 - Userform - display date from textbox in a label or textbox in 'ddd' format
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 10:54 PM
  2. Value of Active TextBox in a UserForm
    By j_Southern in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2015, 10:37 AM
  3. Fill textbox in each active UserForm
    By Laik2013 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-22-2014, 04:12 PM
  4. [SOLVED] Excel 2007, Userform Textbox Date Format and Calendar Control Userform
    By riffology in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2014, 06:18 PM
  5. [SOLVED] Userform textbox to reference active cell with offset
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 12-15-2013, 01:38 AM
  6. Can lookup formula also mirror the format of source cell?
    By Gti182 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2013, 11:44 AM
  7. Custom format in cell from userform textbox
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2009, 09:00 AM

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