Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Dialogue Box - how do I get it to open...

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When I've created a custom dialog box, how do I get it to load on screen when the worksheet is opened or option is selected from a custom menue?
    Thanks

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    which type of dialog box - pre excel 97 era ones (the ones u insert in excel) or those darned vba based ones. If its the first then its
    DialogSheets("Name").Show

    if its the latter then it involves a Load statement, cant remember the exact code as i hardly ever use them.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm using Excel 97, so I guess it's the load statement - if you or anyone else could help that would be great!

    Cheers
    Matt

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    how did you build it - in the vba editor or by right-clicking the sheet tab and inserting a dialog sheet? The original (second) option is considered outmoded but is in my opinion much better.

    [ This Message was edited by: Daniel Cremin on 2002-03-05 07:40 ]

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried the VBA editor - I'm new to dialogue boxes, so will try anything.
    If I use the right hand click option do I just need to include the code above somewhere?

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok heres what i would do - go to excel's main window and right click -insert a dialog sheet and then for the Ok and cancel buttons right click them and enter your code in a macro. Create the text boxes and other controls you want to use - colour the sheet in any colour you want via rectangles inserted and sent to the back on the sheet. and then create a macro to trigger the form containing the code DialogSheets("whatever its called").Show

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for your help.

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    your welcome
    The dialog-sheet (Pre 97) obsessed lad who loves to get around probs like not being able to change background colours. Crap otherwise in Excel!!!

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
  •