I have a timesheet that I've created and wanted to add a pulldown box with
the employee names in it which I've done using the Data/Validation command
but for some reason it only shows 9 of the 18 names?! Is there any way to
make it so you can see the rest of the names or is there a better way to do
this?

Any help is greatly appreciated!

Thanks!
Joe

Hold this... I think I figured it out! Thanks!

"jcolley05" wrote:

I have a timesheet that I've created and wanted to add a pulldown box with
the employee names in it which I've done using the Data/Validation command
but for some reason it only shows 9 of the 18 names?! Is there any way to
make it so you can see the rest of the names or is there a better way to do
this?

Any help is greatly appreciated!

Thanks!
Joe

If you decided to use a ComboBox instead of DV then you have figured it out.


Gord Dibben MS Excel MVP

On Mon, 18 Feb 2008 13:27:03 -0800, jcolley05
wrote:

Hold this... I think I figured it out! Thanks!

"jcolley05" wrote:

I have a timesheet that I've created and wanted to add a pulldown box with
the employee names in it which I've done using the Data/Validation command
but for some reason it only shows 9 of the 18 names?! Is there any way to
make it so you can see the rest of the names or is there a better way to do
this?

Any help is greatly appreciated!

Thanks!
Joe