+ Reply to Thread
Results 1 to 4 of 4

How to make VBA Editor show userform code by default?

Hybrid View

  1. #1
    Registered User
    Join Date
    08-01-2009
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    76

    How to make VBA Editor show userform code by default?

    When you create a userform in the vba editor, then go to another module, then return to the userform, you see the userform object by default and in order to show the code you have to right-click on the userform and select "view code".

    How can I make the "view code" view the default view for the form in the VBA editor? (i.e. so that when the form is selected, I am presented with the code, not the object).

    Moderator's note: Moved from Excel General--6StringJazzer
    Last edited by 6StringJazzer; 04-25-2014 at 07:46 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,298

    Re: How to make VBA Editor show userform code by default?

    You can't change the default. f7 is quicker than the mouse though.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    08-01-2009
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    76

    Re: How to make VBA Editor show userform code by default?

    F7 is quicker ... but still .. bah!

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,298

    Re: How to make VBA Editor show userform code by default?

    The VBE hasn't been altered really since time began, so its options are limited.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Open UserForm when workbook opens (and not the code editor)
    By GavJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 02:12 AM
  2. UserForm wont show based on where VB Editor window is located
    By jbrupert in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2012, 04:38 PM
  3. Userform show (default tab)
    By ilovelagar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-24-2009, 03:32 PM
  4. [SOLVED] VBA Editor: my default font is gone,Courier New(Western)
    By JVL_DarkHorse in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-03-2006, 04:25 PM
  5. Changing the macro editor default settings
    By ppete83606 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2006, 05:50 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1