Consulting

Results 1 to 5 of 5

Thread: Solved: How do I create a "dialog box"...?

  1. #1
    VBAX Regular
    Joined
    Oct 2007
    Location
    Sheffield
    Posts
    63
    Location

    Solved: How do I create a "dialog box"...?

    Hello
    I want to create a 'dialog box' (if that's the right terminology for it)...basically a window/user interface with several fields, which the user fills in. Once they click the 'Enter' button, this data will then be entered into a spreadsheet as a new row.
    Is dialog box the thing it is called? I tried typing this into the excel-help wizard thing but it didn't come up with what I wanted.

    Can anyone point me in the right direction?

    Many thanks,
    Regards
    Lester.

  2. #2
    VBAX Master
    Joined
    Jun 2007
    Location
    East Sussex
    Posts
    1,110
    Location
    A userform is what you are after.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    VBAX Regular
    Joined
    Oct 2007
    Location
    Sheffield
    Posts
    63
    Location
    Quote Originally Posted by rory
    A userform is what you are after.
    That's the ticket. Thanks, rory.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Regular
    Joined
    Oct 2007
    Location
    Sheffield
    Posts
    63
    Location
    Quote Originally Posted by xld
    That's really useful. Thanks.

Posting Permissions

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