DuckieHo

Create a list somewhere on your worksheet of all allowed values.
Go to: Data -> Validation.
Select "List"
The go to source and enter the list cells that you created.
Select the otehr tabs to change the messages you want to create.
Hit Ok.

__________________
WANTED: Socket M Core/Core 2 CPU, SUGO-02 Black, quality 802.11b/g PCI Card
To answer most of your questions: (1) a fridge cannot cool a PC (2) 64-bit OS for over 3.4GB (3) If a PCIe card fits, it will work (4) Resolution, not screen size (5) If you have a question, it is not news (6) Report, not respond to Spam (7) Single/Non-Modular Rail PSUs are NOT better than Multi-Rail/Modular

falcon2099

I like to have validation lists apart from my main spreadsheet... I put it in BA1:BA3



Select the range of cells you want to apply the validation to... H7:H30 (I actually went further to H7:H40)



Select DATA, then VALIDATION



Under the SETTINGS tab, choose LIST under "Allow"

Enter =$BA$1:$BA$3 in the "Source" box (this is where Excel will restrict what gets put into H7:H40)



That's it... you can select whatever you want from the dropdown list in cells H7:H40, and if you try and type something else in there you get an error message

__________________
CPU-Z Validated:
http://valid.x86-secret.com/show_oc.php?id=286288

On RMA:

WishList:
1. 19" (or 21") LCD monitor
2. CPU (Core 2 Duo) will need new mobo for this... only rev2 of the P5LD2 support the C2D's - I guess I'll wait 'til the Pentium D is like the P3 and grossly obsolete

There are only 10 kinds of people in the world today: Those who speak binary, and those who don't.