Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How to change size and location of Msgbox and Inputbox

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a file that has a few Input Boxes and Msgboxes, is there any way that I can adjust the size or move the location of these boxes, since where thay are currently popping up they are blocking some critical data on the worksheet. I can move the critical info on the worksheet, but there a good amount of critical data and currently the boxes are popping up at the center of my worksheet and it would be a lot nicer if I could get the boxes to appear off to a corner of the screen.

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I change the font size in a drop-down input box?

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Belgium
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello,
    It is pretty easy to change the position of the inputboxes, when you write the code:
    s=inputbox("Prompt","title","Default",0,0)
    The two 0 represents the Xposition and Yposition on yourt screen. (0,0) meaning the top left corner.
    Concerning the Msgbox, I don't know how to change their position, sorry.
    Bye

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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