The title says it all. On occasion I have to work with people remotely, and guiding them to a particular sequence or line can be a pain.
Anyone aware of a good method, add-in, etc for doing something like this??
The title says it all. On occasion I have to work with people remotely, and guiding them to a particular sequence or line can be a pain.
Anyone aware of a good method, add-in, etc for doing something like this??
If you go into the VB editor,
right click on the toolbar, just below the menu bar.
Click on 'Customize', put a checkmark in 'Standard', click on close.
You will see 'Ln #, Col #.
Hope this helps.
Have a great day,
Stan
That option's not available in Office 2K...Originally Posted by stanleydgrom
MZ tools has an add-in with an option to add or remove line numbers
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Yes it is, it is a label telling you where the curosr is located and should be sufficient for somone feeding back.
It is on the far right of the toolbar.
My apologies, it is there as xld says (shows how often I use it
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
I didn't know either until I checked what the guy said. I bet the coder didn't get a very big bonus for that facility
Not really what your after, but I thought I'ld post this anyway...
There is an undocumented feature of VBA called Erl.
It's hidden in the Information Class of VBA.
To see it you need to Show Hidden Members, right-click in the Object Browser.
To use it:
[VBA]
Sub ErrorLineTest()
On Error GoTo ErrorLineTest_Error
1 MsgBox "This is messagebox.", vbInformation, "Title 1"
2 MsgBox "This is the error line.", , vbCritical, "Title2"
Exit_Here:
Exit Sub
ErrorLineText_Error:
Dim errorLineNumber As Integer
errorLineNumber = Erl
MsgBox "Error on line: " & errorLineNumber, vbCritical, "ERROR"
Resume Exit_Here
End Sub
[/VBA]
Marcster.
Posting Permissions
Reply With Quote
