Using XP Pro and Excel 2002/3
I have been asked to provide an Excel spreadsheet
that people can use as a purchase request form.
Some of the fields will contain data that is already
defined. For example ...
Project Name. A list of project names exists.
Commodity codes and associated description.
A list of codes and their descriptions exists.
Is there some way that I can provide a drop down
for cells? Like a combo box in Access for instance?
I realise I could create a form with VBA behind it,
but I was wondering if that sort of functionality
could be provided at the cell level, without going
to the complication of a form.
Thanks,
Roy
Bob Phillips - 02 Feb 2007 11:47 GMT
Data Validation. See http://www.contextures.com/xlDataVal01.html

Signature
HTH
Bob Phillips
(there's no email, no snail mail, but somewhere should be gmail in my addy)
> Using XP Pro and Excel 2002/3
>
[quoted text clipped - 19 lines]
> Thanks,
> Roy
RzB - 02 Feb 2007 12:19 GMT
Bob,
That's very helpful.
Many thanks,
Roy
"Bob Phillips" <bob.NGs@somewhere.com> wrote in message
> Data Validation. See http://www.contextures.com/xlDataVal01.html