LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 123
Default MsgBox popping up on entering of certain text in any row of Column X

Dear Experts:

I need help with a macro:

As soon as a user enters a certain string, say "text" in any row of
Column A (with the exception of the column heading) , a msgbox is to
pop up, saying "This is not allowed!"

I would favour a macro solution, but if there is a built-in
functionality to perform this, that would be great too.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My 3rd Msgbox is popping up in wrong position JMay Excel Programming 4 April 23rd 07 07:56 PM
Disable Text to Column from popping up automatcally Newbee via OfficeKB.com New Users to Excel 0 January 31st 07 01:52 PM
Entering variables on Msgbox prompt renegan[_6_] Excel Programming 3 January 4th 06 06:54 PM
MsgBox keeps popping up Rob[_17_] Excel Programming 1 January 25th 05 03:49 AM
Eliminating Excel msgbox from popping up while macro is running. dpdutke Excel Programming 2 November 23rd 03 07:55 PM


All times are GMT +1. The time now is 02:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"