john-tvh / vbe_extras Goto Github PK

Describe the bug
Live Code Info does not update when cursor moves directly between a Property Get and matching Property Let/Set

To Reproduce
Steps to reproduce the behavior:

1. In a Module with a Property Get and a Property Let/Set (with the same name), click on the Property Get and wait for Live Code Info to update
2. Click on the Property Let/Set (with the same name) ... Live Code Info does not update, still reflecting the info for the Property Get
3. The reverse is also the case

Code sample

Option Explicit

Dim mNum As Long

Property Let Num(value As Long)
    mNum = value
End Property
Property Get Num() As Long
    Num = mNum
End Property

Expected behavior
Live Code Info should update to reflect the correct Property

Please complete the following information:
VBE_Extras v1.3.1.0 [Release], build 20 Apr 2023 17:15:23
LGF: v2.1.0.0
LGS: v3.1.2.0
LFF: v3.6.11.0
.NET Framework 4.8.4614.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Debugger attached
Dev device
Excel 365 (16.0, 16227, WIN64, VBA7)
VBE 7.01
UI Lang: en-US
Host: excel.EXE v16.0.16227.20280
LCI NS: True
EE NS: False

Describe the bug
'Full Screen' does not maximise the VBE window if it is currently in a 'normal' state

To Reproduce
Steps to reproduce the behavior:

1. Open VBE
2. Ensure VBE window is in a 'normal' state (ie not minimised or maximised)
3. Select the "FullScreen" option
4. Docked windows (Immediate window, Project etc) are hidden but the VBE window is not maximised.

Expected behavior
When the docked windows are hidden, the VBE window should be maximised.

Please complete the following information:
VBE_Extras v1.4.1.1 [Release], build 30 Aug 2023 20:25:46
LGF: v2.1.0.0
LGS: v3.1.4.0
LFF: v3.6.15.0
VEH: v20221118.04
.NET Framework 4.8.9167.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Dev device
Excel 365 (16.0, 16731, WIN64, VBA7)
VBE 7.01.1131
UI Lang: en-US
Host: EXCEL.EXE v16.0.16731.20078
LCI NS: True

Describe the bug
When VBE_Extras is (re-)loaded after having been unloaded, it fails to start correctly displaying a "Failed to get CommandBar ... VBE_Extras cannot load" message in a dialog box.

To Reproduce
Steps to reproduce the behavior:

1. Start the VBE (any host)
2. Unloaded VBE_Extras (in the VBE: Add-Ins > Manage Add-Ins)
3. Loaded VBE_Extras (in the VBE: Add-Ins > Manage Add-Ins)
4. See message in dialog box

Expected behavior
VBE_Extras should re-load

Screenshots

Logs
n/a

Please complete the following information:
VBE_Extras v1.3.0.0 [Debug], build 17 Apr 2023 20:24:02
LGF: v2.1.0.0
LGS: v3.1.2.0
LFF: v3.6.11.0
.NET Framework 4.8.4614.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Dev device
Excel 365 (16.0, 16227, WIN64, VBA7)
VBE 7.01
UI Lang: en-US
Host: EXCEL.EXE v16.0.16227.20280
LCI NS: False
EE NS: False

Additional context
n/a

Describe the bug
Make Option Explicit adds new declarations in wrong procedure when there are many declarations for the 'same name' are added across multiple procedures at once.

To Reproduce
Steps to reproduce the behavior:

1. Activate Module 'dp_GetSelections' in supplied Workbook
2. Run 'Make Option Explicit'
3. In the 'Before using Make Option Explicit' dialog, check all 3 checkboxes
4. In the 'Module or Proc/Prop' dialog, select 'Proc/Prop'
5. After adding a number of declarations, shows a dialog "an error 'Duplicate declaration in current scope' while compiling ... please fix and try again" ... that scope being the SearchSKUIndexBySearchString() Function

Expected behavior
No duplicate declarations.

Screenshots

Frequency of bug
Every time ... the bug is 100% consistent.

Please complete the following information:
VBE_Extras v1.4.1.4 [Debug], build 14 Nov 2023 14:20:48
LGF: v2.2.0.0
LGS: v3.1.8.0
LFF: v3.7.2.0
VEH: v20230831.05
.NET Framework 4.8.9181.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Dev device
Excel 365 (16.0, 16924, WIN64, VBA7)
VBE 7.01.1131
UI Lang: en-US
Host: EXCEL.EXE v16.0.16924.20124
Exp: S-GET, S-CCAS, RAM

Describe the bug
'Themes' does not work with a non-English (eg Spanish) 'Office Display Language'

To Reproduce
Steps to reproduce the behavior:

1. If it is not already, set the 'Office Display Language' to be non-English (eg Spanish) and then re-start the host application
2. In the VBE_Extras main menu, select View > Themes > Apply a Theme ... select a Theme then OK
3. See message 'Failed to apply theme - could not get handle to the Options Window ...'

Expected behavior
Theme should be applied

Frequency of bug
Every time the steps in 'To Reproduce' are carried out.

Context

• 'Office display language' is non-English?

Please complete the following information:
VBE_Extras v1.4.2.0 [Debug], build 15 Nov 2023 15:12:13
LGF: v2.2.0.0
LGS: v3.1.8.0
LFF: v3.7.2.0
VEH: v20230831.05
.NET Framework 4.8.9181.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Excel 365 (16.0, 16924, WIN64, VBA7)
VBE 7.01.1131
UI Lang: es-ES
Host: excel.exe v16.0.16924.20124
Exp: LCI-NS, S-GET, S-CCAS, RAM

Describe the bug
Error window appears for TaskCanceledException in 'Connect(WinForms)' exception handler on launching VB IDE

To Reproduce
Steps to reproduce the behavior:

1. Open Excel (from file or shortcut)
2. Press Alt+F11 to launch VB IDE
3. Error appears

Expected behavior
No error

Screenshots

Logs
logs.zip

Please complete the following information:
VBE_Extras v1.4.1.4, build 26 Oct 2023 18:41:06
LGF: v2.2.0.0
LGS: v3.1.6.0
LFF: v3.7.1.0
.NET Framework 4.8.9181.0
CLR: v4.0.30319
Microsoft Windows 10.0.22621 : X64
Excel 365 (16.0, 16924, WIN64, VBA7)
VBE 7.01.1131
UI Lang: en-US
Host: EXCEL.EXE v16.0.16924.20124
Exp: NEWA

Describe the bug
Main menu items (including items under 'Conditional Compilation Arguments', 'Backup this Project' and others) are inappropriately enabled when no VBA projects (including AddIns) are open

To Reproduce
Steps to reproduce the behavior:

1. Open the VBE
2. Close all VBA Projects including any AddIns
3. Open the main menu
4. Note which menu items in the menu are enabled

Expected behavior
Only appropriate main menu items should be enabled when no VBA projects (including AddIns) are open.

Frequency of bug
All the time when no VBA projects (including AddIns) are open.

Please complete the following information:
VBE_Extras v1.4.3.0 [Debug], build 5 Dec 2023 16:15:43
LGF: v2.2.0.0
LGS: v3.1.9.0
LFF: v4.0.0.0
VEH: v20230831.05
.NET Framework 4.8.9181.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Debugger attached
Dev device
Excel 365 (16.0, 17029, WIN64, VBA7)
VBE 7.01.1131
UI Lang: en-US (menu names English)
Host: excel.exe v16.0.17029.20028
Exp: S-GET, S-CCAS, RAM
OA: none

Describe the bug
Cannot find the declaration for, or rename, ActiveX Controls in Worksheet CodeModules (though does find references)

To Reproduce
Steps to reproduce the behavior:

1. Add an ActiveX Control to a Worksheet
2. Add an event handler in the CodeModule behind the Worksheet (example below)
3. Move the cursor to CommandButton1
4. Ask VBE_Extras to go to the declaration or rename

Private Sub CommandButton1_Click()
    Debug.Print CommandButton1.Name
End Sub

Expected behavior
Should find and allow renaming of ActiveX Controls in Worksheet CodeModules

Please complete the following information:
VBE_Extras v1.1.2.0 [Debug], build 12 Aug 2022 09:59:20
LGF: v2.0.3.0
LGS: v2.2.7.0
LFF: v3.5.2.0
.NET Framework 4.8.4515.0
CLR: v4.0.30319
Microsoft Windows 10.0.19043 : X64
Dev device
Excel 365 (16.0, 15427, WIN64, VBA7)
VBE 7.01
UI Lang: en-US
Host: EXCEL.EXE v16.0.15427.20194

Describe the bug
After updating Attributes for UserForm Modules when the UserForm designer is visible, no history is recorded

To Reproduce
Steps to reproduce the behavior:

1. Add a UserForm to the project
2. Ensure the designer is visible
3. Update the Exposed or Description Attribute
4. Note no history

Expected behavior
History should continue to be tracked

Please complete the following information:
VBE_Extras v1.3.1.0 [Debug], build 21 Apr 2023 13:02:38
LGF: v2.1.0.0
LGS: v3.1.2.0
LFF: v3.6.11.0
.NET Framework 4.8.4614.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Debugger attached
Dev device
Excel 365 (16.0, 16227, WIN64, VBA7)
VBE 7.01
UI Lang: en-US
Host: excel.EXE v16.0.16227.20280
LCI NS: True
EE NS: False

Describe the bug
Members with a name that is a single-character - where that character appears as the last character of a String are being identified as Code references, not String references

To Reproduce
Steps to reproduce the behavior:

1. Add code, below
2. Position code on the declaration for 'a'
3. Click on 'References for code at cursor'
4. The 'a' in the first of the 3 Debug.Print lines is identified as being a Code type reference (the other two as a String type reference)

Sub Foo()
    Dim a As String
    Debug.Print "--a"
    Debug.Print "-a-"
    Debug.Print "a--"
End Sub

Expected behavior
The 'a' in all 3 Debug.Print lines should be identified as being a String type reference)

Frequency of bug
Every time.

Please complete the following information:
VBE_Extras v1.4.2.0 [Debug], build 23 Nov 2023 15:31:13
LGF: v2.2.0.0
LGS: v3.1.9.0
LFF: v4.0.0.0
VEH: v20230831.05
.NET Framework 4.8.9181.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Debugger attached
Dev device
Excel 365 (16.0, 17029, WIN64, VBA7)
VBE 7.01.1131
UI Lang: en-US (menu names English)
Host: excel.exe v16.0.17029.20028
Exp: S-GET, S-CCAS, RAM

Describe the bug
Does not find references to Functions or Property Gets when used directly as the value of a named argument. Does find other references and also finds references to variables, statics and other types when used as the value of a named argument.

To Reproduce
Sample code:

Sub Foo()
    Bar lVal:=GetNum
    Bar GetNum
End Sub

Sub Bar(lVal As Long)
    Debug.Print Now, lVal
End Sub

Function GetNum() As Long
    GetNum = 42
End Function

... get references for GetNum ... will find only 3 with the reference in line Bar lVal:=GetNum being omitted.

Expected behavior
Find all 4 references.

Please complete the following information:
VBE_Extras v1.1.6.0 [Debug], build 13 Jan 2023 12:17:17
LGF: v2.1.0.0
LGS: v3.0.1.0
LFF: v3.6.4.0
.NET Framework 4.8.4515.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Dev device
Excel 365 (16.0, 15831, WIN64, VBA7)
VBE 7.01
UI Lang: en-US
Host: EXCEL.EXE v16.0.15831.20208

Describe the bug
Dialog appearing in VBA Projects that have one or more broken Type Library references: The VBE reported an error (COMException) in the 'Menus' exception handler (command 'Info for code at cursor'): Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))

To Reproduce
Steps to reproduce the behavior:

1. Open relevant VBA Project
2. Click on any declaration or reference
3. For example, select menu item 'Info for code at cursor'
4. See error

Expected behavior
No such error dialog

Screenshots

Frequency of bug
Is specific to VBA Projects that have one or more broken Type Library references ... occurs for majority of VBE_Extras functions.

Please complete the following information:
VBE_Extras v1.4.2.0 [Debug], build 20 Nov 2023 08:46:55
LGF: v2.2.0.0
LGS: v3.1.9.0
LFF: v4.0.0.0
VEH: v20230831.05
.NET Framework 4.8.9181.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Dev device
Excel 365 (16.0, 17029, WIN64, VBA7)
VBE 7.01.1131
UI Lang: en-US (menu names English)
Host: EXCEL.EXE v16.0.17029.20028
Exp: S-GET, S-CCAS, RAM

If you are having a problem with updating VBE_Extras to version 1.1.4.0 from a prior version, note that changes have been made to the installation process for this version of VBE_Extras which may result in the update failing for a small number of users that already have a prior version installed. If you are updating to this new version but still see an old version number in the 'About' window, please go to Control Panel > Programs and Features (or Settings > Apps) and uninstall VBE_Extras (all versions if multiple are present), then use this link to go to the downloads page and install the latest version:

The VBE Help, VBE_Extras download page

Describe the bug
'VBE_Extras Helper' right-click context menu not showing for some Shapes.

To Reproduce
Steps to reproduce the behavior:

1. Create an Excel workbook that includes an "OLE Object" item (as distinct from a "Form Control" item)
2. Ensure the 'VBE_Extras Helper' AddIn is loaded
3. Right-click the "OLE Object" and note that no context menu appears; right-click the "Form Control" and note that a context menu does appear

Expected behavior
A context menu should appear when right-clicking an "OLE Object"

Please complete the following information:
VBE_Extras v1.4.1.1 [Release], build 30 Aug 2023 20:25:46
LGF: v2.1.0.0
LGS: v3.1.4.0
LFF: v3.6.15.0
VEH: v20221118.04
.NET Framework 4.8.9167.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Dev device
Excel 365 (16.0, 16731, WIN64, VBA7)
VBE 7.01.1131
UI Lang: en-US
Host: EXCEL.EXE v16.0.16731.20078
LCI NS: True

Describe the bug
Renaming some types in PowerPoint results in a NullReferenceException, for example renaming the VBProject

To Reproduce
Steps to reproduce the behavior:

1. Open a VBProject in PowerPoint
2. Right-click on the name of the VBProject in the Project window
3. Select Extras > Refactor > Rename this project
4. See error

Expected behavior
Allow rename of VBProject

Please complete the following information:
VBE_Extras v1.1.6.0 [Debug], build 24 Jan 2023 15:49:37
LGF: v2.1.0.0
LGS: v3.0.2.0
LFF: v3.6.5.0
.NET Framework 4.8.4515.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Dev device
PowerPoint 365 (16.0, 15928, WIN64, VBA7)
VBE 7.01
UI Lang: en-US
Host: POWERPNT.EXE v16.0.15928.20216

Describe the bug
The VBE_Extras Toolbar repeatedly moves out of position (having briefly moved into the correct position) when Live Code Info is running and new info is being displayed.

To Reproduce
Steps to reproduce the behavior:

1. Open the VBE, start Live Code Info
2. Move caret repeatedly onto, and then away from, a declaration/reference (ie to make Live Code Info 'show info')

Screenshots
If applicable, add screenshots to help explain your problem.

Please complete the following information:
VBE_Extras v1.4.2.0 [Debug], build 23 Nov 2023 17:31:28
LGF: v2.2.0.0
LGS: v3.1.9.0
LFF: v4.0.0.0
VEH: v20230831.05
.NET Framework 4.8.9181.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Dev device
Excel 365 (16.0, 17029, WIN64, VBA7)
VBE 7.01.1131
UI Lang: en-US (menu names English)
Host: EXCEL.EXE v16.0.17029.20028
Exp: S-GET, S-CCAS, RAM

Describe the bug
References of a variable or static following the 'Is' keyword are not found

To Reproduce
Steps to reproduce the behavior:

1. In example code below, put cursor on the declaration for obj
2. Click on 'References for code at cursor'
3. The declaration is found, the reference following the 'Is' keyword is not found

Dim oExcel As Application
Dim obj As Object
If oExcel Is obj Then
    ' stuff
End If

Expected behavior
Both references should be found

Please complete the following information:
VBE_Extras v1.1.2.1, build 8 Sep 2022 12:24:52
LGF: v2.0.3.0
LGS: v2.3.2.0
LFF: v3.5.4.0
.NET Framework 4.8.4515.0
CLR: v4.0.30319
Microsoft Windows 10.0.19043 : X64
Debugger attached
Dev device
Excel 365 (16.0, 15427, WIN64, VBA7)
VBE 7.01
UI Lang: en-US
Host: EXCEL.EXE v16.0.15427.20210

Describe the bug
Cannot identify declaration of Type element when there are multiple spaces between its name and the 'As' keyword.

To Reproduce
Steps to reproduce the behavior:

1. See example code below
2. In the line with the Debug.Print statement, press F12 on value1 and the declaration is found ... however, press F12 on value2 and the declaration is not found with a message saying "Could not find the declaration for 'value2'"

Type MyType
    value1 As Long
    value2    As Long
End Type

Sub Foo()
    Dim t As MyType
    Debug.Print t.value1, t.value2
End Sub

Expected behavior
The declaration for value2 should be found, the same as it is for value1

Please complete the following information:
v0.9.1.2 [Debug], build 25 Jun 2022 15:37:43
LGF: v2.0.3.0
LGS: v2.2.7.0
LFF: v3.4.8.0
.NET Framework 4.8.4515.0
CLR: v4.0.30319
Microsoft Windows 10.0.19043 : X64
Excel 365 (16.0, 15225, WIN64, VBA7)
VBE 7.01
UI Lang: en-US
Host: EXCEL.EXE v16.0.15225.20288

Describe the bug
Error is reported when a 'match for literal value at cursor' is on line 1 of a Module (ArgumentException)

To Reproduce
Steps to reproduce the behavior:

1. Add code with a string literal on line 1 of a Module eg

Const test As String = "abc"

Sub Foo()
    Debug.Print "abc"
End Sub

... note the Const line is line 1

3. Click on "abc" in the Debug.Print line
4. Select menu option to get 'Matches for literal value at cursor'
5. See error

Expected behavior
No such error, dialog is shown listing matches for "abc".

Frequency of bug
Every time the above scenario is replicated.

Logs
Argument_231211_083113_206_Excel.txt

Please complete the following information:
VBE_Extras v1.4.3.0 [Debug], build 11 Dec 2023 12:48:23
LGF: v2.2.0.0
LGS: v3.1.10.0
LFF: v4.0.1.0
VEH: v20230831.05
.NET Framework 4.8.9181.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Dev device
Excel 365 (16.0, 17029, WIN64, VBA7)
VBE 7.01.1131
UI Lang: en-US (menu names English)
Host: EXCEL.EXE v16.0.17029.20068
Exp: S-GET, S-CCAS, RAM
OA: none

Describe the bug
Host app locks up when change procedure between Sub and Function

To Reproduce
Steps to reproduce the behavior:

1. Create Function: Function Foo(lNum As Long) As String
2. Edit to: Sub Foo()
3. Cursor down
4. Ctrl+Z (ie undo)
5. Host app locks up

Expected behavior
Host app does not lock up

Logs
n/a ... no Exception / Error displayed

Please complete the following information:
VBE_Extras v1.3.0.0 [Debug], build 17 Apr 2023 15:23:49
LGF: v2.1.0.0
LGS: v3.1.2.0
LFF: v3.6.11.0
.NET Framework 4.8.4614.0
CLR: v4.0.30319
Microsoft Windows 10.0.19045 : X64
Dev device
Excel 365 (16.0, 16227, WIN64, VBA7)
VBE 7.01
UI Lang: en-US
Host: EXCEL.EXE v16.0.16227.20280
LCI NS: False
EE NS: False

Describe the bug
When a device has multiple monitors attached and a Form is shown and closed on a non-primary monitor, when the Form is re-shown it is always back on the Primary monitor (should be on the same secondary monitor)

To Reproduce
Steps to reproduce the behavior:

1. Show any Form eg with a list of declarations
2. Move the Form onto a secondary monitor
3. Close the Form
4. Show the Form, it will be back on the primary monitor

Expected behavior
The Form should be shown on the same monitor that is was visible on when closed (so long as that monitor is still attached)

Please complete the following information:
VBE_Extras v1.0.0.0 [Debug], build 20 Jul 2022 15:55:00
LGF: v2.0.3.0
LGS: v2.2.7.0
LFF: v3.5.0.0
.NET Framework 4.8.4515.0
CLR: v4.0.30319
Microsoft Windows 10.0.19043 : X64
Dev device
Excel 365 (16.0, 15225, WIN64, VBA7)
VBE 7.01
UI Lang: en-US
Host: EXCEL.EXE v16.0.15225.20288