Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Column must be filled before going another column.

And Validation is under Data not Tools.

Lower yet.


Gord

On Thu, 24 Aug 2006 09:03:54 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Data Validation is triggered by an incorrect entry, not by no entry at all so
this method cannot possibly work for user.

Rating.......low


Gord Dibben MS Excel MVP

On Thu, 24 Aug 2006 03:13:02 -0700, Naveen
wrote:

See "Tools- Validation"

*** Please do rate ***



"kyoshirou" wrote:

Hi..
Can i know how should i go with; in a way that users have to enter data for
column1 first before go to other column2. If user forget to enter for
column1, it will prompt the users.


thanks~


Gord Dibben MS Excel MVP
Reply
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
Stock data manipulation [email protected] Excel Worksheet Functions 1 June 12th 06 11:06 PM
Column picked randomly with probability relative to number of entr Neil Goldwasser Excel Worksheet Functions 4 May 30th 06 08:55 AM
how can i multiply two columns edgar Excel Worksheet Functions 7 March 2nd 06 03:29 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM


All times are GMT +1. The time now is 04:45 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"