Softpedia >Windows >Programming >Other Programming Files >Code VBA >  Changelog

Code VBA Changelog

What's new in Code VBA 10.0.56

May 1, 2024
  • IntelliSense now also lets you select the ability to create a new function procedure, which ads a stub function o the required type under the procedure actually being worked on.
  • Fixed disappeared top level calsses in Variable Excel menu
  • Find now also includes global procedures in its search.
  • Fixed inserting code when working from Immediate window did not recognize this as active window

New in Code VBA 10.0.55 (Apr 27, 2024)

  • Fixed incidents where the class variable was inerted unlinked to the method.
  • Fixed inserting code in Immediate window no longer working.
  • Fixed error 'SendKeys cannot run inside this application because the application is not handling Windows messages.'
  • Fixed missing dot in contruct like Me.Refresh

New in Code VBA 10.0.54 (Apr 22, 2024)

  • Fixed bugs in generated code from Find > Search results
  • Fixed error in get_IsNewLine

New in Code VBA 10.0.53 (Apr 13, 2024)

  • Intellisense now recognizes special objects like Sheet1 and ThisWorkbook.
  • When return variable is hidden, the Procedure Call Builder dialog did not look balanced. The extra space is now made to good use.
  • Temporarily disabled overruling MS Intellisense for Me. in Access forms
  • Fixed error codevba.Finder.GetLibraryWords
  • Fixed error codevba.Finder.CreateSynonyms

New in Code VBA 10.0.52 (Apr 12, 2024)

  • Intellisense now recognizes special objects like Sheet1 and ThisWorkbook.
  • When return variable is hidden, the Procedure Call Builder dialog did not look balanced. The extra space is now made to good use.
  • Fixed error codevba.Finder.CreateSynonyms

New in Code VBA 10.0.51 (Apr 11, 2024)

  • Find feature added to the object menu. It returns a submenu showing all procedures for the current object that are related to the selected word.
  • Stop MS VBA Intellisense interfering when working from object variable folloed by dot.
  • Fixed SEHExceptions incidents

New in Code VBA 10.0.49 (Mar 11, 2024)

  • Procedure call builders now preview any code changes in the arguments property sheets instantly. Before, the cursor had to exit the grid before peview was updated.
  • You can now set the preference to not add automatic prefixes to variables. As an alternative for the prefixes variables now can be 1. for arguments, the argumentname or the procedurename in case of return types. To prevent conflicts, when needed the variables get a number suffix (e.g. Len1 as returntype for the Len function - as alternative to intLen)
  • You can now set the preference to decide if you want intellisense to start after Alt-Space or Shift-Space individually.

New in Code VBA 10.0.48 (Mar 1, 2024)

  • The Variable Builder is redesigned. It now supports selecting application class types in addition to standard classes
  • The Variable menunow supports selecting application class types for instant variable insertion.
  • Intellisense now recognizes class variable assignment such as wb= and after CTRL-Space opens a menu showing all manners in which you can complete the assignment expression, including adding Set (if absent): ActiveWorkbook, Workbooks.Add, Sheet1.Parent, etcetera.
  • Shortened menu for variable assignment expressions, the extra menu for selecting a return variable is not appropriate in such a use case.
  • Positioned Folder Builder and String Builder lower in String menu reflecting lesser common use.
  • Added class variables in context as possible items to use in a specific class variable assignment.
  • Removed superfluous menus for class variable assignment that involved a collection and its Parent.
  • Fixed the selected submenu class type niet being taken in account in more complex assignments.
  • Fixed incomplete property value list in case of mixed enumes such as Borders.LineStyle
  • Fixed some cases for With submenu where the class variable gets lost under longer menu such as setting value using VBA function.
  • Changed Chart variable prefix to chrt to avoid confilct with VBA.chr procedure.
  • Removed incorrect property Visible menu for Sheets where type was set to Chart.

New in Code VBA 10.0.46 (Feb 14, 2024)

  • Fixed: return type variable should not be visible in dialog if called on right side of an assignment sentence
  • Fixed: Workbooks.Add Template parameter not distinghuishing selected argument.
  • Removed Search from toolbar, current moving to Google not considered to have sufficient value.
  • Removed Help from toolbar. Reason: icon esthetics low resolution. Also, it dupplicates what is available down the main menu.
  • Better intellisense when starting after object variable.
  • Intellisense only showing methods and properties when starting after object variable + dot.

New in Code VBA 10.0.43 (Nov 26, 2023)

  • Procedure Builder selectable arguments now also include Object type variables.
  • Object menu now includes procedure arguments that are of an Object type

New in Code VBA 10.0.42 (Nov 23, 2023)

  • Fixed Select Case Builder not picking up enum values belonging to function return variable
  • Fixed Select Procedure Builder not picking up enum values for arguments from application specific types.

New in Code VBA 10.0.40 (Jun 14, 2023)

  • Extended Intellisense menu with functions written bij the user.
  • Fixed error when user class has multiple procedures with the same name.

New in Code VBA 10.0.39 (Apr 12, 2023)

  • Fixed error incident With multiple variables
  • Fixed Code Explorer flicker in class modules
  • Corrected issue with Tidy indentation

New in Code VBA 10.0.38 (Mar 20, 2023)

  • Fixed Goto menu at top not opening
  • Fixed error occuringen when opening some Excel menu items from within Access

New in Code VBA 10.0.37 (Jan 29, 2023)

  • Some minor fixes

New in Code VBA 10.0.36 (Nov 18, 2022)

  • Some fixes to the 'Quick' menu not always ending in the correct position.
  • Improved declaration of Collection variable as part of Collection » to automatically 'Set ...= New Collection'
  • Added popup list to select from to the Format procedure Format argument.
  • Changed expected type to Date for Date argument for FormatDateTime procedure.
  • Minor improvement to VBA » Date and Time menus.
  • Folder Builder… added to the intellisense menu for String type.
  • Builders (New) variable builder now also recognizes 'as' (lowercase) before type and now creates the intended new variable.
  • Fixed mouse position interference with intellisense menu.

New in Code VBA 10.0.35 (Nov 5, 2022)

  • Type intelliSense now also works for function names return e.g. Function1 = .
  • Added: Folder Builder to intellisense for Strings
  • Fixed: Folder Builder not starting from VBA » Folder raquo; .
  • Fixed error that occurred when selecting procedure starting from End Sub to beginning.
  • Prevent Autotidy as started by getting outside of procedure event should not happen when selecting lines using Shift-ArrowDown.
  • Fixed: ? missing from inserted function when inserted into Immediate Window from Code Explorer,
  • Removed: value 'True' - remove from Select Case builder, not helpful.

New in Code VBA 10.0.34 (Oct 27, 2022)

  • Added support for insertion of methods and properties of custom classes from both menu and Code Explorer.
  • Insertion of collection property of custom classes changed to insertion of Public variable to make coding collection operations easier.
  • In Procedure Builders argument popups moved New Variable to top, above existing variables, as the former is statistically the most likely choice.
  • Added Me to the top of the Object menu, in case of inside a custom class module
  • Demo fragments appearing at the top of the Fragments menu
  • Several places missing ellipsis ... added

New in Code VBA 10.0.33 (Sep 27, 2022)

  • Extend String IntelliSense with Excel.Application.GetOpenFilename
  • Empty line added in submenu for procedure with one argument (e.g. Debug.Print)
  • Fixed: IntelliSense did not work correctly when inserting Fragments in If Then and similar condition positions.
  • Removed: using Quick menu on IntelliSense, not useful

New in Code VBA 10.0.32 (Sep 21, 2022)

  • IntelliSense now also fully supports functions written by the user under submenu Project
  • Fixed: IntelliSense did not work corectly when inserting functions in If Then and similar condition positions.
  • Fixed: Names » Forms now gain give the names and also in submenu the names of its controls.
  • Fixed: error IndexOutOfRangeException in CurrentProjectFileName

New in Code VBA 10.0.31 (Sep 21, 2022)

  • IntelliSense now supports extra string functions page with ., StartsWith and EndsWith, Contains and more.
  • New: in code window when cursor in a hyperlink pressing F1 opens the web page.
  • New preference 'Hide Object extended menu'. When checked, the submenus for properties and arguments only provide variables and VBA functions, but not submenus for the available objects. Reason is that these have a low chance of being relevant and may be considered by some users to make the menu unnecessarily large. If needed the user van select the blank item, and complete the line using IntelliSense.
  • Fixed IntelliSense not working in If _ Then when the line has more content after Then.
  • Fixed conflict between AutoTidy and debugging.
  • Corrected argument types and handling in Excel, notably the Range Property Cell1.

New in Code VBA 10.0.30 (Sep 1, 2022)

  • Enum value insertion (long or short or numeric) now is determined dynamically, preference is removed.
  • Added feature of being able to run For Each in the Immediate bwindow allowing easy creation of all kinds of lists or other actions on items in collection.
  • Some improvements in Constant Builder
  • Fixed wrong proposed names e.g. wb.Add
  • Fixed bug in code WorksheetFunctio.Lookup
  • Fixed reported bug Value cannot be null in ProcedureSubmenuItems
  • Fixed case with Quick Menu not working

New in Code VBA 10.0.28 (Aug 25, 2022)

  • Easier moving through menus by avoiding interference with mouse pointer position.
  • More complete and consistent menus by more generalized underlaying model.
  • Fixed AutoTidy for handling older While Wend loop.
  • Fixed Quick menu

New in Code VBA 10.0.24 (Jul 9, 2022)

  • Tidy indentationnow also can be set automatix on leaving edited procedures.
  • Two code formatting bugs fixed.
  • Which methods and properties appear at the top of the menu can now be changed by the user.
  • Improved speed of menus.
  • Fixed some Unhandled Exceptions
  • Fixed wrong object variable being used when switching from one of the same type to another.
  • Added empty item for selection to leave open to users to enter something else if available items don't include what the user wants, e.g. entering a constant.

New in Code VBA 10.0.23 (Jun 27, 2022)

  • Inserting code from menu to Immediate window now also available while debugging
  • Improved adding error handling fragments which now distribute themself correctly over a procedure that already contains code.
  • When opening a new project a Module is automatically added if there is none - depending on your prefernce setting
  • Also, the first procedure in the module in your project is selected.

New in Code VBA 10.0.22 (Jun 17, 2022)

  • Empty choice for variable added to list of submenu for variables, for the case where you want to insert a specific value yourself.
  • Items under Object now also appear under IntelliSense menu
  • Fixed error occurring when With path involved collection
  • Empty line removed when incertain fragments with module reference
  • Removal of outdated fragments
  • Fixed Prefix not added when creating/using variable in fragment

New in Code VBA 10.0.21 (Jun 9, 2022)

  • Menu Object now shows properties of the required when started after =.
  • Fixed fragments Content mismatch with HTMLElement, now is AppendContentValue
  • Fixed Variable Builder, Add to top, wrong preview content

New in Code VBA 10.0.20 (May 31, 2022)

  • Limitation on use of methods in the Immediate window that return an Object removed.
  • Named ranges now appear in the Object menu for direct use.
  • Value of property displayed now for all Objects that appear in the Object menu.
  • Arrays of a type now also included as variables in the IntelliSense menu.
  • Export in Code Explorer now sets the name of module as the default in the Save As dialog.
  • If Show Tooltip preference is off, fix that F1 makes the web help page appear.
  • Fix that value in Expression field in Select Case dialog is not picked up.
  • Breaklines added for type VBA in the IntelliSense menu.
  • Improved item variable naming & handling in For Each constructions.

New in Code VBA 10.0.19 (May 24, 2022)

  • Shortened menus when working from Immediate window.
  • Improved menu for setting Bolean type property (shorter).
  • Fixed error occuring in displaying tooltip when property has Null value.
  • Tooltips with values now also work for other Office applications than Excel.
  • Better handling of very long values when displaying them in tooltip.
  • Fixed tooltips no longer appearing if Object variable is not first class citizen (e.g. Sheet1)

New in Code VBA 10.0.18 (May 12, 2022)

  • Use menus to try out behaviour of code in Immediate window.
  • Fixed code insertion when automating using Early binding.

New in Code VBA 10.0.17 (May 1, 2022)

  • In Access, under the Object menu, procedures in forms and modules now can act on controls of itself or other forms.
  • If the number of Forms or Reports is large, only open forms are displayed to prevent clutter and possible speed issues.
  • IntelliSense nor also is available for function return value setting (fx=)

New in Code VBA 10.0.16 (Apr 28, 2022)

  • In Access, under the Object menu, proicedures in forms and modules now can act on controls of itself or other forms.
  • If the number of Forms or Reports is large, only open forms are displayed to prevent clutter and possible speed issues.
  • IntelliSense nor also is available for function return value setting (fx=)

New in Code VBA 9.0.39 (Aug 20, 2021)

  • Under menu 'Objects' now names that are recognized by VBA such as Me and Sheet1 are recognized allowing you to directly use them without first having to declare variables. Note: the objects in MS Access still need to adjusted.
  • The additional 'Objects' also are available in the Procedure Builder Class variable selection box
  • Extended the fragments syntax so that the Fragment Inserter now can let you select appropriate method, e.g. MailItem .Draft or .Send

New in Code VBA 9.0.37 (Jul 29, 2021)

  • Outlook now has Create Item fragments for MailItem, ContactItem, etcetera.
  • New: Fragment Inserter dialog that allows you to select variables in the code context to use in the code fragment.
  • In Procedure Builder for WorksheetFunction renoved With checkbox
  • WorksheetFunction menu now sorted alphabetically
  • Date Picker and some other features now (as it should have been) available for licensed users.

New in Code VBA 9.0.36 (Jul 18, 2021)

  • Fixed names of sheets in Excel no longer appearing in the Code Explorer.
  • Implemented the best suitable (default) Set-ting of the main class objects of the office application, saving you the effort of doing it in an explicit step. For example the two steps...
  • Dim win as Window: Set win = ActiveWindow
  • win.Close
  • ... are now reduced to one
  • ActiveWindow.Close
  • This is also done for Excel: Workbook, Word and Publisher: Document, PowerPoint: Presentation, DAO: CurrentDB. On most cases the Active is used, but in special suitable cases ThisWorkbook or ThisDocument is selected as the more logical default. You can overrule the default by first inserting the Set statement for the object variable.
  • Fixed missing object variable in ADO.Connection object
  • GoSub label code bug fixed
  • Fixed generated code for MailItem Attachments.Item

New in Code VBA 9.0.35 (Jul 16, 2021)

  • Implemented the best suitable (default) Set-ting of the main class objects of the office application, saving you the effort of doing it in an explicit step.
  • For example the two steps...
  • Dim win as Window: Set win = ActiveWindow
  • win.Close
  • ... are now reduced to one
  • ActiveWindow.Close
  • This is also done for Excel: Workbook, Word and Publisher: Document, PowerPoint: Presentation, DAO: CurrentDB. On most cases the Active is used, but in special suitable cases ThisWorkbook or ThisDocument is selected as the more logical default. You can overrule the default by first inserting the Set statement for the object variable.
  • Fixed missing object variable in ADO.Connection object
  • GoSub label code bug fixed
  • Fixed generated code for MailItem Attachments.Item

New in Code VBA 9.0.34 (Jul 9, 2021)

  • Fixed Access on some systems not closing fully (hidden process stays alive).

New in Code VBA 9.0.33 (Jul 6, 2021)

  • Fixed exe distributions containing older version or even 'corrupt file'.
  • Fixed OK button of InputBox Builder not fitting in dialog.
  • Fixed on some occasions HandleExit appearing below end of procedure.
  • Improved placement of cursor after MsgBox Builder code insertion.

New in Code VBA 9.0.30 (Jun 18, 2021)

  • Better (shorter) code produced by the InputBox Builder
  • Select Case builder now allows not selecting a variable in the first line
  • Fixed incidental occurring error on opening VBE
  • Improved some dialog access keys

New in Code VBA 9.0.28 (Jun 9, 2021)

  • Fixed bug with tab size in Condition Builder on some systems
  • Fixed bug uncheck Multiline not working in If Then Builder
  • Enum Builder now has code preview pane
  • Fixed: msgbox appearing when opening PowerPoint VBE

New in Code VBA 9.0.26 (Jun 8, 2021)

  • Enum Builder now has code preview pane
  • Fixed: msgbox appearing when opening PowerPoint VBE