PC Review


Reply
Thread Tools Rate Thread

Data Validation enter values with VBA

 
 
XR8 Sprintless
Guest
Posts: n/a
 
      10th Apr 2010
I currently have a Spreadsheet running a tipping competition which works
well, however would like to add additional functionality to it.

I have cells setup which are data validated to a list on the sheet and
have four values to select from which are

None, Team 1, Draw, Team 2

These come up in a drop down box.

What I would like to be able to do is to have the data filled
automatically in a group of cells dependent on the value in another cell.

For example

In Cell A10 i put in H and Cell F10 which has the data validated list
always has the value None to start with the list coming from Cells Q10
(none), R10 (team 1), S10 (Draw), T10 (Team 2), I would like it to fill
with team 1, or if I put A in Cell A10 I would like to have it fill with
Team 2.

I would also then like to have the next seven cells down (F11: F17) fill
with either Team 1 or Team 2 depending on the value in cell A10

Is this possible?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
custom data validation on cells with data validation values AKrobbins Microsoft Excel Worksheet Functions 2 21st Jun 2011 04:20 PM
Data Validation - enter first letter and find? Don Microsoft Excel Misc 0 20th May 2009 06:50 PM
Data validation won't take. I enter it, hit ok. It ignores me. =?Utf-8?B?bWljaGlnYW5jeWNsb25l?= Microsoft Excel Crashes 2 15th Nov 2006 03:26 PM
How do i set up data validation to only enter yes or no? =?Utf-8?B?cmVuZWU=?= Microsoft Excel Worksheet Functions 2 18th Oct 2005 01:31 PM
Validation of cell to enter data gilbert Microsoft Excel Worksheet Functions 39 9th Mar 2004 11:01 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:34 AM.