Results 1 to 4 of 4

Thread: VBA Office 97

  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Santa Clara, California, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA Office 97

    I have a question about writing functions and if it is possible to define a list of arguments.

    When I use MsgBox and I go to select the buttons to use, VBA produces a list of choices. Is it possible for me to create a function that does the same thing?

    TIA!

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: VBA Office 97

    When you go to select the buttons to use in a MsgBox, AutoComplete is displaying for you a list of the built-in constants for MsgBox buttons.

    You can create your own custom-defined constants (that will show up in AutoComplete) but to do so you'll first need to define them in a class module.

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Office 97

    You can create a VBA function that loads a userform that does whatever you want it to do.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Office 97

    > first need to define them in a class module.


    Eileen? We've found a volunteer (grin!)

Posting Permissions

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