Display Message with Macro in Spreadsheet

Sponsor

Excel Vba Display Message with Macro in Spreadsheet [Q]

I have to create microsoft excel spreadsheet with a range of cells with excel formula. I would like to create display of message in excel spreadsheet

” This cell contains excel formulas. Please do not type here”

when a user clicks on a range of cells with excel formula.

Excel Vba Display Message with Macro in Spreadsheet [A]

I think using excel worksheet protection is much easier and safer (excel macros setting can be disabled).

But if you want:

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim FormulaCells As Range

Set FormulaCells = Nothing
On Error Resume Next
Application.EnableEvents = False
Set FormulaCells = Intersect(Target, _
Target.Cells.SpecialCells(xlCellTypeFormulas), _
Me.UsedRange)
Application.EnableEvents = True
On Error GoTo 0

If FormulaCells Is Nothing Then
‘ok
Else
MsgBox “Your selection contains formulas”
Application.EnableEvents = False
Application.Goto Me.Range(”a1″)
Application.EnableEvents = True
End If

End Sub

If you want to try, rightclick on the excel worksheet tab that should have this behavior. Select view code. Paste this into the newly opened code window. I went back to A1. You should change that to where you want them to be if they selected a range with at least one cell with a excel formula.

Then back to microsoft excel to test it out.

Ps. Lots of things get disabled when you run excel vba macros. Try the undo or redo
buttons.

Rate This Tips:

Incoming excel search terms

macro in spreadsheet,vba display message,excel macro display a message,excel macro error message,excel vba display message,how to display message with time delay in excel,display message macro,excel display message,excel macro not show error messages,macro how to display a message on error,macro to display a range of cells in message box,msg excel,assign a macro to display a message,cell displays macro,code to copy worksheet and disable macro,conditional error message excel,copy worksheet messagebox vba,creating a loading message for excel macro,disable error msg excel workbook,disable error popups excel vba,disable excel macros message,display cells in macro in excel,display error macro,display error message macro,display error message when macros disabled,display error messages from a macro excel,display error messages from excel macro,display macro in excel,display macro on spreadsheet,display macro spreadsheet,display many cells in one message in a macro in vb,display message box in excel,display message entire worksheet,display message for 1 second excel,display message on opening a worksheet macro,display message on worksheet change excel,display message when macro disabled,display message when opening excel,display multiple message in excel by vba,display multiple messages vba,display numbers on worksheet vba,displaying excel spreadsheets,displaying message excel worksheet,displaying multiple message boxes in excel,ecel spreadsheet vba target rows,email multiple rows excel macro,error message excel macro,error message macro excel,excel,excel change cells in macro when a new row is inserted

Related Excel Tips

• Excel Time Macros on Weekday Only (0)
• Embedded Chart on Worksheet Using Excel Vba (2)
• Week Functions in Vba (0)
• Rename New Worksheet (0)
• Quick Way Determine The First and Last Business Day of the Month (1)
• Protect Range of Rows and Columns in Worksheet with Macro (1)
• Macro Code to Format Worksheet (2)

Comments

• Archives

  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

• Categories

  • Excel Vba
  • Excel Tips
  • Excel Formulas
  • Excel Date Functions
  • Excel Spreadsheet
  • Excel Worksheet
  • Excel Miscellaneous

• Partners

  • Search Xls
  • Xls Files

• Latest Excel Tips

  • Search-Engine-Excel.Com - The Helpful One for You
  • Switch Minutes to Seconds in Excel
  • Excel Polynomial Trendline
  • Sending Multiple Personalized Email from Excel
  • Excel Sumif Multiple Criteria
  • Remove Hyperlinks in Excel
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria
  • Streamlining Macro Created by Macros Recorder
  • Copying Cells Which Include Conditional Formatting in Worksheet
  • How to Draw Lines on User Form

• Most Viewed Excel Tips

  • How to Divide a Number With “Less Than” Sign? - 29,641 views
  • Macro VBA to Remove Characters in String of Text - 20,144 views
  • Date Calculation Start Date Minus Year, Month and Days - 18,941 views
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria - 17,407 views
  • Combine Multiple Workbooks Overcome 255 Char Limit - 14,006 views
  • Insert Introduce Time Delay in Macro Vba - 13,916 views
  • Protect Range of Rows and Columns in Worksheet with Macro - 13,536 views

• Best Excel Tips

  • Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
  • How to Remove Excel Vba Macro Button (5.00 out of 5)
  • Delete Worksheet (5.00 out of 5)
  • Copy from Worksheet (5.00 out of 5)
  • How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
  • Remove Hyperlinks in Excel (5.00 out of 5)
  • Unprotect Worksheet Password (5.00 out of 5)

• Excel Tags

  Excel Vba vba excel xcel vba vba xcel Excel Tips Excel Formulas excel formula xcel formulas xcel tips excel vba add worksheet excel vba create new workbook excel worksheet formulas xcel formula Excel Worksheet microsoft excel tips excel vba date functions excel date function Excel Spreadsheet excel vba active worksheet excel vba worksheet change excel vba worksheet name excel vba worksheet_change excel vba delete worksheet excel vba select worksheet excel vba clear worksheet excel vba copy worksheet excel vba macro add new worksheet how to add new worksheet excel miscellanous