#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default data validation

Hi, all,

Rather than VBA codes, are there any other ways to validate the cell's value
which is set by the underlying formula?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default data validation

"Jack Zhong" wrote:
Rather than VBA codes, are there any other ways to validate the cell's value
which is set by the underlying formula?


Perhaps try a look at Debra's nice coverage at:
http://www.contextures.com/xlDataVal07.html
Excel -- Data Validation -- Custom Validation Criteria Examples
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default data validation

Thank you, it is just what I am looking for.


"Max" дÈëÓʼþ
...
"Jack Zhong" wrote:
Rather than VBA codes, are there any other ways to validate the cell's

value
which is set by the underlying formula?


Perhaps try a look at Debra's nice coverage at:
http://www.contextures.com/xlDataVal07.html
Excel -- Data Validation -- Custom Validation Criteria Examples
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default data validation

"Jack Zhong" wrote:
Thank you, it is just what I am looking for.


Glad to hear that, Jack !
Thanks for the note-back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
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
Data validation dakotasteve Excel Worksheet Functions 13 August 5th 06 01:28 AM
Macro question Chris Excel Worksheet Functions 12 July 7th 06 01:23 AM
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 11:08 PM.

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

About Us

"It's about Microsoft Excel"