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

Thread: Custom Dialog box

  1. #1
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a book that gives the commands
    Insert / Macro / Dialog, for V5
    which is supposed to enable the editing of a custom dialog box, already containing the OK and cancel buttons. You are then supposed to be able to add other items like drop down boxes, edit boxed ect...

    does anyone know how to do this in XL97

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Surrey, United Kingdom
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Sounds like you're talking about userforms. Go to 'Creating Userforms' in the Excel VBA help, or there's an excellent example to get you going on the front page of MrExcel.com, at the very bottom of the screen under 'VBA Macros - Examples', first one in the list.

    Hope this helps,

    Nibbs

  3. #3
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    perfect thanks



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
  •