Results 1 to 8 of 8

Thread: [EXCEL] Improve VBA IDE

  1. Jul 13th, 2009, 07:13 AM #1
    agmorgan
    agmorgan is offline

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    [EXCEL] Improve VBA IDE

    After using some IDEs in other languages for a few years, coming back to do a bit of VBA has left me feeling quite frustrated and unproductive!

    A few things that immediately spring to mind are:
    1. Delete a whole line (and a keyboard shortcut)
    2. Duplicate a whole line to the line below (and a keyboard shortcut)
    3. Refactoring
    4. Highlight other instances of selected word


    How would I go about implementing this myself?
    Refactoring would be a lot harder so lets focus on the first 2 to start with.

    I don't really know how the Add Ins work, can they be created in VB(A) or are they C++?
    Last edited by agmorgan; Jul 31st, 2009 at 04:33 AM.
    Help me with my PKR Hand History Tool
    AutoUpdater - ActiveX Control Format numbers to Significant Figures
    Delete Recent Projects from VB6 IDE Emulate Windows 95 Powertoys Regex in Excel
    Reply With Quote Reply With Quote
  2. Jul 13th, 2009, 08:37 AM #2
    Siddharth Rout
    Siddharth Rout is offline
    Discovering Life Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    12,001

    Re: [EXCEL] Improve VBA IDE

    Delete a whole line (and a keyboard shortcut)
    Ctrl +Y
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved

    MyGear:
    ★ CPU ★ Ryzen 5 5800X
    ★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
    ★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
    ★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
    ★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
    ★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
    ★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
    ★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
    ★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
    ★ Keyboard ★ TVS Electronics Gold Keyboard
    ★ Mouse ★ Logitech G502 Hero
    Reply With Quote Reply With Quote
  3. Jul 13th, 2009, 09:22 AM #3
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: [EXCEL] Improve VBA IDE

    I don't think you can use VBA to create an addin, but you can use VB6.

    It has been a while since I've done it, but I'm fairly sure that the way they interact with the code is as a group of arrays - one containing each line of code, and one containing the start position of each Sub/Function/etc, and a few others too.


    While it doesn't have the features you asked about, MZTools (link in my signature) has a VBA edition, which I would recommend.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  4. Jul 13th, 2009, 06:53 PM #4
    agmorgan
    agmorgan is offline

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    Re: [EXCEL] Improve VBA IDE

    This page (and others on msdn) says that you can create them from VBA
    http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

    However, I fail on step 3
    Code:
    From the File menu, select New Project, and then select Add-In Project.
    I am using Office 2007 and this page is referring to Office XP.

    Is it something that was taken out between versions or is it perhaps a feature that is not available in the license that I have?

    Does anyone else have it?
    Help me with my PKR Hand History Tool
    AutoUpdater - ActiveX Control Format numbers to Significant Figures
    Delete Recent Projects from VB6 IDE Emulate Windows 95 Powertoys Regex in Excel
    Reply With Quote Reply With Quote
  6. Jul 14th, 2009, 03:53 AM #5
    westconn1
    westconn1 is offline
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: [EXCEL] Improve VBA IDE

    well i do not see any such option in excel 2000
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete
    Reply With Quote Reply With Quote
  7. Jul 14th, 2009, 04:07 AM #6
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: [EXCEL] Improve VBA IDE

    It isn't made very obvious, but it seems to me that article is for the Developer edition of Office - so editions like Standard/Pro/... probably won't have it.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  8. Jul 15th, 2009, 06:33 AM #7
    agmorgan
    agmorgan is offline

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    Re: [EXCEL] Improve VBA IDE

    I can't seem to find the developer edition on the Microsoft site.
    Is it called something else in 2007?
    Help me with my PKR Hand History Tool
    AutoUpdater - ActiveX Control Format numbers to Significant Figures
    Delete Recent Projects from VB6 IDE Emulate Windows 95 Powertoys Regex in Excel
    Reply With Quote Reply With Quote
  9. Jul 15th, 2009, 08:04 AM #8
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: [EXCEL] Improve VBA IDE

    The 2007 editions do not seem to include anything like it.

    I'm fairly sure it isn't available any more (and vaguely remember Robdog888 commenting on it), but couldn't find any useful info. A search on Amazon only found developer editions for Office XP or earlier.

    I have a suspicion that VSTO (Visual Studio[.Net] Tools for Office) is capable of creating addins, but have no experience with it.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width