Posted to microsoft.public.excel.programming

Darin Kramer Darin Kramer is offline

external usenet poster

Posts: 397

Custom Data Validation

Hi there,

Im looking to create some data validation in say cell a2, that says if
cell a1 = "a", then allow a2 to accept a number, if a1 = anything else
then dont allow entry into a2.
Is it possible using custom data validation...? I cant seem to get any
sensical result from using custom...

Regards

Darin

*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
custom data validation on cells with data validation values	AKrobbins	Excel Worksheet Functions	2	June 21st 11 04:20 PM
Data Validation, Custom	leimst	Excel Worksheet Functions	1	June 13th 08 12:23 AM
Custom Data Validation	MuppetBaby	Excel Discussion (Misc queries)	2	July 30th 07 07:06 AM
custom data validation	Matt	Excel Discussion (Misc queries)	1	February 3rd 07 10:27 PM
Custom data validation	Guy Normandeau	Excel Discussion (Misc queries)	3	April 18th 06 04:12 PM

All times are GMT +1. The time now is 07:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us