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

    Excel/VBE (What pane is that?)

    All right, here's a question for which I can't find an answer in the VBE help files for Excel.

    What are the names of the two drop-down boxes immediately underneath the tool bar in VBE?

    Typically, when I double-click on a blank area of a UserForm I get a skeletal event "UserForm_Click", the first drop-down list shows me 'UserForm", and the second shows me "Click". I usually select "Activate " from the second drop down .....

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel/VBE (What pane is that?)

    Chris,

    These dropdowns are not unique to Excel. However the one on the left lists all objects available to the current module, and the one on the left lists all procedures available to the selected object. If an object has any event procedures associated with it, the skeleton for such event procedures (such as Activate) are available in the left dropdown list. I think they are just intended as a convenient method of navigating through lenghty modules and for saving you the bother of typing something like :

    Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

    End Sub

    Andrew C

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

    Re: Excel/VBE (What pane is that?)

    Thanks, Andrew; I could call them the "objects" and "events" lists and get away with it, I guess.

  4. #4
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel/VBE (What pane is that?)

    Wlee If you hover your mouse over them, you will get "Objects" pop up as a tool tip for the left combo and "Procedure" as a tool tip for for right one.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel/VBE (What pane is that?)

    Chris, you probably would get away with it though it may not be totally accurate as apart from listing all the objects available to a module, the left dropdown has a (General) item, which if selected would give a dropdown list of general (not event driven) procedures / functions that have been coded by the user in the module.

    Andrew C

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

    Re: Excel/VBE (What pane is that?)

    Bryan, thanks. I had tried this as a first resort, but for some reason didn't get the pop-up. Today I do, and I'll use those names, since that's what Excel97 supplies.

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

    Re: Excel/VBE (What pane is that?)

    > procedures / functions that have been coded by the user in the module

    Andrew, thanks for this extending clue. I'd not noticed those before.

    As I mentioned in my reply to Bryan, I'll stick with the supplied names, because other users will see those names.

    Now to explore my own world of creations ......

Posting Permissions

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