+ Reply to Thread
Results 1 to 5 of 5

Increasing font size in window bar?

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Increasing font size in window bar?

    Hi,

    Does anyone know whether there is a facility to make the window bar font bold, or a little bigger? It's current form is a little small


    Thanks
    Attached Images Attached Images

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,882

    Re: Increasing font size in window bar?

    Not so easy since it requires API call to manipulate Title bar.

    One method is to hide title bar through API. Then place suitable label/caption etc to serve as title bar.

    See code written by Leith Ross in link below to remove title bar from userform.
    http://www.excelforum.com/excel-prog...-userform.html

  3. #3
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Increasing font size in window bar?

    ... remove the title bar and then you find the userform is frozen in position on screen - you need more code (SetCapture API) so the user can drag the userform if needed. And when you move to 64 bit (if ever) the code needs to be modified.

    The Window title bar font and size are system settings - leave them alone but use a label to provide a suitably sized heading top left of the userform.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,882

    Re: Increasing font size in window bar?

    Ah thanks. Didn't consider userform being frozen in place.

    Leith's code has 64 bit version further down the thread in link.

  5. #5
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Increasing font size in window bar?

    Thanks Chaps, I'll have a look

+ 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. 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
  2. Set initial Userforml font size through Properties Window instead of code
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2014, 04:28 PM
  3. Replies: 3
    Last Post: 07-06-2011, 01:30 PM
  4. Replies: 5
    Last Post: 04-22-2011, 10:21 AM
  5. Replies: 0
    Last Post: 04-13-2011, 06:48 AM
  6. Increasing the font size in a data validation list
    By PHUAG in forum Excel General
    Replies: 2
    Last Post: 03-23-2010, 09:25 AM
  7. [SOLVED] Data Valadition window font size
    By agcoupe in forum Excel General
    Replies: 1
    Last Post: 05-30-2006, 01:35 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