» Display a record with a right mouse click using VBA in Microsoft Excel
CATEGORY - General Topics in VBA
VERSION - All Microsoft Excel Versions
The row of an active cell is to be displayed in a message box with a right mouse click in columns A:E
Answer:
Insert the following code in the appropriate modules.
Place the code below into the This Workbook module.
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Dim intCounter As Integer
Dim txt As String
If Target.Column > 5 Then Exit Sub
Cancel = True
For intCounter = 1 To 5
txt = txt & Cells(Target.Row, intCounter) & vbLf
Next intCounter
MsgBox txt
End Sub
Book Store:
Recommended Books:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Retire Young, Retire Rich
- Microsoft Windows XP Step by Step (With CD-ROM)
- Advanced modelling in finance using Excel and VBA
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
No comments have been submitted.


