Hi, Now that I figured out how to use Control F3 to pop open the Data Validation dialog in Excel 2007, Here's my next question. How do I use the values in a column of the same sheet as valid values for a list box? Thanks. Jim ________________________________ This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.