» Highlight a selected range with a MsgBox using VBA in Microsoft Excel
CATEGORY - Cells, Ranges, Rows, and Columns in VBA
VERSION - All Microsoft Excel Versions
Place the code below into the standard moduleSub GetRange() Dim Rng As Range On Error Resume Next Set Rng = Application.InputBox(prompt:="Enter range",Type:=8) If Rng Is Nothing Then MsgBox "Operation Cancelled" Else Rng.Select End If End Sub
Book Store:
Recommended Books:
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Financial Statement Analysis with S&P insert card
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- How to Use Financial Statements: A Guide to Understanding the Numbers
No comments have been submitted.
