Thanks Thanks:  0
Likes Likes:  0
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 24

Thread: How to open UserForm code by VBA?

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Are you talkin about opening a designers for in stand alone VB?

    If so, export the file form VBA, and then double click it to open it in VB

  2. #12
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-20 01:59, TsTom wrote:
    Are you talkin about opening a designers for in stand alone VB?

    If so, export the file form VBA, and then double click it to open it in VB
    I believe he wants to open up the Actual code
    in the VBA Editor...similar to hyperlinking
    in Excel97 to a code module (Not poss in Ecel2000) OR Application.Goto [name of sub routine]
    EXCEPT he wants to goto the Userform Code.

    Not sure if you can ??

  3. #13
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am totally lost, but here's a stab in the dark.


    Sub OpenTheVBE()
    Application.VBE.ActiveCodePane.Show
    End Sub




  4. #14
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-20 02:22, Ivan F Moala wrote:

    I believe he wants to open up the Actual code
    in the VBA Editor...similar to hyperlinking
    in Excel97 to a code module (Not poss in Ecel2000) OR Application.Goto [name of sub routine]
    EXCEPT he wants to goto the Userform Code.

    Not sure if you can ??
    Thanks Ivan! You got the problem just right. That is indeed what I would like to be able to do, to open the actual code for editing in Excel VBE. I know that you can do it whit Goto Reference:= "Sub something" if the the Sub something() is just a regular Excel VBA module, but it gets tricky when the Sub something() is in UserForm code. There must be some way to do this, I just haven't figured it out yet. I believe the main issue here is how to name the Reference right. Think hard fellows...

    Thx in advanz

  5. #15
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just to raise my little problem back on the saddle from the page #2. Pls, anybody!

  6. #16
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Im dropping of the sheet here! Anybody?

  7. #17
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Cum on dudes and daisies, someone has to know this?

  8. #18
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Any MVPs on line? Come on, shoot me with your wisdom...

  9. #19
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-21 14:19, Sbirro Cornuto wrote:
    Any MVPs on line? Come on, shoot me with your wisdom...
    Try this;

    Sub GoTo_UserForm()
    Set Application.VBE.ActiveCodePane = _
    ThisWorkbook.VBProject.VBComponents("UserForm1").CodeModule.CodePane

    Application.VBE.ActiveCodePane.Show

    End Sub

    Userform1 being the userform code to show


    Ivan

  10. #20
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey! My shot in the dark wasn't that far off then!

    Go Ivan!



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
  •