Automatically Selecting An Option in a Data Valdidation Cell
 

Hi,

I am trying to write a script that will run when a particular cel
changes and I have got it all to work except the last little bit.
want the script to select a value from a cell with data validation i.
if range("countryversion") = "version 1.0", then rang
("selected_country_version") which is a data validation cell wil
select "version 1.0" from the list of data it has to validate.

Is there anyway to do this? I have setting the range.value but thi
just produces an application/object-defined error.

Any help would be great

Thank

--
soteman200
-----------------------------------------------------------------------
soteman2005's Profile: http://www.excelforum.com/member.php...fo&userid=2907
View this thread: http://www.excelforum.com/showthread.php?threadid=50630