LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default HELP! cell validate

i want to validate two cells

first one: only alphabet a-z A-Z

second one: it should be a number but it can have a
decimal place 0-9 & .

i want a MsgBox "error" to appear if the user enters in
something not valid.

how do i validate these? pleaaaase help!
 
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
xl 2007 how to validate that cell 1 invalid if cell 2 not blank declaire9 Excel Discussion (Misc queries) 0 April 13th 10 06:57 PM
how do i validate a cell that has a formula wAYNE Excel Discussion (Misc queries) 4 March 1st 10 07:13 PM
Validate entry based on another cell value Dearoledad Excel Discussion (Misc queries) 3 May 15th 09 10:47 PM
Can I validate a cell only if a certain condition is met? Anita Excel Discussion (Misc queries) 2 July 11th 07 06:34 PM
Validate value in cell Mike[_40_] Excel Programming 0 August 4th 03 05:54 PM


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

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"