How to create Dropdown lists not using Data Validation
Maybe you could create a userform that gets the information from the user?
I don't use Sharepoint, so I don't know if userforms work under that.
Catlady wrote:
Does anyone have any suggestions on creating dropdown lists other than using
Data Validation. I'm creating a checklist in Excel and I want to control what
users enter and also do some conditional formatting (i.e. select completed,
the cell goes green, overdue, the cell turns red).
I expect to have about 20 items to track and for each one the options will
be different. The reason I don't want to use Data Validation is that I want
to publish this to Sharepoint and Sharepoint Excel web part services do not
support Data Validation.
Would appreciate any suggestions. Thanks!
--
Dave Peterson
|