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

Thread: forms

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Andy Devine
    Posts
    106
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi am using forms (under data menu) for data entry...is there anyway to increase width of text boxes or make data feilds "2 rows high" instead of 1 as makes easier to enter details if adding long descriptions..?
    thanks
    Andy

    Andy Devine

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Manchester UK
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you know how to use the forms in VBA, you can design your own form and have the boxes as big as you want.

  3. #3
    MrExcel MVP
    Colo's Avatar
    Join Date
    Mar 2002
    Location
    Kobe, Japan
    Posts
    1,456
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default

    Hi Andy.
    As far as I know, you cannot do that with the forms.
    Useing Userform is the better way as jamienwood said.
    Hope this helps + pen pineapple apple pen!

    Masaru Kaji aka Colo - cellmasters.net

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Andy Devine
    Posts
    106
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi thanks for replies
    dont know how to do my own forms - is it fairly straightforward? if so, can u point me in right direction?
    thanks
    Andy
    Andy Devine

  5. #5
    New Member
    Join Date
    Apr 2002
    Location
    Kansas City, MO
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When in excel hit ALT-F11 to start VBA,
    goto INSERT and select USERFORMS,
    if you dont see your tool box, goto VIEW and select TOOLBOX,
    there you can insert boxes and set them to whatever size you want


  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Howdy,

    I'll send you a VBA training thing I have. It shows you how to design etc. Make sure you follow the instructions at the beginning to the letter

    Audiojoe
    Ground control to Major Tom

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
  •