+ Reply to Thread
Results 1 to 4 of 4

MsgBox Font Size change

  1. #1
    Robert Christie
    Guest

    MsgBox Font Size change

    Hi

    If I call up a MsgBox with code as below, can I change the font size of that
    MsgBox using VBA?
    Sub MsgBox1()
    If MsgBox("Caution!! You are about to clear data from this worksheet."
    & vbCr & vbCr & _
    "Is that your intension?." & vbCr & vbCr & _
    " CONTINUE Y/N?", vbYesNo) <>
    vbYes Then Exit Sub

    TIA

    --
    Thank you

    Regards

    Aussie Bob C.
    Using Windows XP Home + Office 2003 Pro

  2. #2
    Robert Christie
    Guest

    RE: MsgBox Font Size change

    Hi
    Just found an answer to my post, which is NO.
    Looks like I have to use a user form.
    --
    Aussie Bob C.

    "Robert Christie" wrote:

    > Hi
    >
    > If I call up a MsgBox with code as below, can I change the font size of that
    > MsgBox using VBA?
    > Sub MsgBox1()
    > If MsgBox("Caution!! You are about to clear data from this worksheet."
    > & vbCr & vbCr & _
    > "Is that your intension?." & vbCr & vbCr & _
    > " CONTINUE Y/N?", vbYesNo) <>
    > vbYes Then Exit Sub
    >
    > TIA
    >
    > --
    > Thank you
    >
    > Regards
    >
    > Aussie Bob C.
    > Using Windows XP Home + Office 2003 Pro


  3. #3
    AA2e72E
    Guest

    RE: MsgBox Font Size change

    The font & size used by the message box is controlled by the settings in
    Display Properties + Appearance. To see the Display Pproperties dialogue,
    right click on your desktop & click properties.

    "Robert Christie" wrote:

    > Hi
    > Just found an answer to my post, which is NO.
    > Looks like I have to use a user form.
    > --
    > Aussie Bob C.
    >
    > "Robert Christie" wrote:
    >
    > > Hi
    > >
    > > If I call up a MsgBox with code as below, can I change the font size of that
    > > MsgBox using VBA?
    > > Sub MsgBox1()
    > > If MsgBox("Caution!! You are about to clear data from this worksheet."
    > > & vbCr & vbCr & _
    > > "Is that your intension?." & vbCr & vbCr & _
    > > " CONTINUE Y/N?", vbYesNo) <>
    > > vbYes Then Exit Sub
    > >
    > > TIA
    > >
    > > --
    > > Thank you
    > >
    > > Regards
    > >
    > > Aussie Bob C.
    > > Using Windows XP Home + Office 2003 Pro


  4. #4
    Robert Christie
    Guest

    RE: MsgBox Font Size change

    Hi AA

    "AA2e72E" wrote:

    > The font & size used by the message box is controlled by the settings in
    > Display Properties + Appearance.


    I believe that will change all settings throughout my Computer, not what I
    require.
    Thanks for the post

    Regards Aussie Bob C.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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