View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Outlook, eh? Outlook, eh? is offline
external usenet poster
 
Posts: 35
Default How to edit drop down list source

Thanks for the suggestion!
I unhid all of the sheets, looked on another tab (which only has one of the
data validation lists) and looked around the HTML/XML scripting, but can't
find where I can add a value to the existing list of values (for example, we
have H, V, S, B, P for holiday, vacation, sick, birthday, personal that
automatically inserts 8 hours into the time sheet). I want to add W for
Weather, which wasn't tough to add so that it displays in the list of
choices, but it doesn't make 8 hours appear. Instead you get an error message
that was created within the script.



"Outlook, eh?" wrote:

Hello,
My predecessor made a Timesheet form. I have been able to add information by
going through datavalidationinput message, but I am not sure how to access
the data that actually impacts calculations. I can see the source (that
begins with =, but I am not sure where it is located or how to edit it).

Any help would be great!
-B