Was looking for how to find and go to a line number in the code window since the information of the line and col is visible. While not as straight forward as Ctrl+F, found this code snippet.
https://social.msdn.microsoft.com/F...er-in-a-module-in-the-vba-editor?forum=isvvba
https://social.msdn.microsoft.com/F...er-in-a-module-in-the-vba-editor?forum=isvvba
Code:
'---------------------------------------------------------------------------------------
' Method : Jumper
' Author : Blackhawk
' Author : [url]http://stackoverflow.com/questions/32381879/how-to-jump-to-line-number-in-vba-editor[/url]
' Date : 9/3/2015
' Purpose: Jump to a line number in the VBE. A line in the code module or class you have open in
' the current code pane. Usage: Type Jumper 64 in the immediate window and hit enter to be taken
' to line 64. If that line is already in view, this does nothing, but if it's off the screen, it
' will automatically be scrolled to the center of the screen
' Remember to Trust access to the VBA project object model
' Keywords: jump to line, go to line
'---------------------------------------------------------------------------------------
Public Sub Jumper(line As Long)
Application.VBE.ActiveCodePane.SetSelection line, 1, line, 1
End Sub