how do I creat an input form in excel 2007 to include drop down bo

[DaveH]

The standard input form in 2007 does not allow dop down boxes to allow the
inputter to choose from options defined in a range on another page.

Any ideas?

 

[Nick Hodge]

Dave

What do you mean by 'standard input form' If you mean data validation, name
the range on the new sheet that you are using as the list and then use this
range in the DV on the other sheet, that'll work

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Per Jessen]

The standard input form in 2007 does not allow dop down boxes to allow the
inputter to choose from options defined in a range on another page.

Any ideas?

Hi

Try to define the input options as a Named Range and then refer to the
name, just remember to put a equal sign before the name, ie
=MyNamedRange.

I haven't testet it but i think it will work.

Regards,
Per