+ Reply to Thread
Results 1 to 3 of 3

is it possible to use VBA to change a userforms caption font to be bold and chge color?

  1. #1
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    is it possible to use VBA to change a userforms caption font to be bold and chge color?

    Hello All,

    is it possible to use VBA to change a UerForm's caption font to be bold and also change colors?

    I do see this suggestion here in EF

    https://www.excelforum.com/excel-gen...tion-font.html

    Any thoughts?

    Regards,

    John
    Last edited by JJFletcher; 04-20-2021 at 06:42 AM.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: is it possible to use VBA to change a userforms caption font to be bold and chge color

    They are part of the standard screen settings.
    Depending on Windows versions you can get some changes by persoanalising your overall settings in control panel or equivalent.
    Downside - the change affects all programs.
    torachan.

  3. #3
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: is it possible to use VBA to change a userforms caption font to be bold and chge color

    Hi Torachan,

    Thanks for your feedback - I appreciate that!

    Hoping this would have been an easy fix. "UGH"

    Thanks again

    Regards,

    John

+ 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. Replies: 2
    Last Post: 10-25-2022, 08:06 PM
  2. [SOLVED] dynamically created option buttons - change font color of caption
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2018, 11:44 AM
  3. [SOLVED] Add font color, bold, italic to string
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-13-2015, 12:00 PM
  4. Mouse rolls over to cell will change the tab color, font color and tp bold type
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-20-2013, 10:36 AM
  5. [SOLVED] Change label caption's font color based on value in another textbox
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-19-2013, 01:59 PM
  6. Replies: 2
    Last Post: 02-04-2013, 02:00 PM
  7. how to change to Bold or color font of statusbar
    By newby in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-26-2007, 11:39 PM

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