Results 1 to 6 of 6

Warning Message

Threaded View

  1. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Warning Message

    Hi,

    You can use "Data Validation" for this.

    1. Select cells P3:R3
    2. Select Data -> Data Validation
    3. Validation Criteria -> Allow Custom
    4. Enter the Formula - >=COUNTA($P3:$R3)<=1
    5. Enter the "Error Alert" you want to see on the "Error Alert" tab
    6. Ok

    once you complete the above steps, copy cells P3:R3 paste it down the whole range.

    See the below image and attached file for more details.
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting a Warning message!
    By vishal2628 in forum PowerPoint Formatting & General
    Replies: 1
    Last Post: 04-18-2013, 02:55 PM
  2. Warning message. And changing data without close message.
    By pinguino in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2013, 03:01 PM
  3. [SOLVED] How to pop up a warning message before any Excel automatic update link reminder message
    By billj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2013, 10:41 AM
  4. message box warning
    By M3Cobb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2006, 06:50 PM
  5. Pop up warning message!
    By canix in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2005, 03:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1