New Posts  All Forums:Forum Nav:

excel help please! - Page 2

post #11 of 12
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.
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
post #12 of 12
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

New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming