×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Data Validation Lists

Data Validation Lists

Data Validation Lists

(OP)
Hello again,

I have a  hidden worksheet that contains data used in validation lists.

Now what I would like to do is set it up to where if the users needs to add another item to that list, he can enter it directly into the list without having to unhide the sheet or ask me to update the list for him/her.

Can someone please show me how to code this so the user can update the list for themselves and have the data flow inot the correct named list in hidden sheet?

Thanx so much

David

RE: Data Validation Lists

David,

I'm trying to put something together for you, but may take me a couple of days.

Regards,
Mike

RE: Data Validation Lists

David,

If you are monitoring this thread, I have sent you a demo workbook.  If anyone else is interested, I'd be happy to send you a copy, also.


Regards,
Mike

RE: Data Validation Lists

Hi!
I'm new here; but I just read this thread and I too, would very much like to know how to add a new item to a list.
I'd appreciate getting a copy too.
Many thanks!
Lori

RE: Data Validation Lists

Hi,
Msmith, could you send me the demo as well.

RE: Data Validation Lists

Lori & crablare,

I need your email addresses!  



Regards,
Mike

RE: Data Validation Lists

Sorry about the delay - I was out of town and swamped by crocodiles!
Please email me at lch1950@icqmail.com
Many, many thanks!!!!

RE: Data Validation Lists

Hi would you send the demo workbook to me?. My email is yellowman08@hotmail.com... thx in advance

RE: Data Validation Lists

MSmith,

I'm interested in your demo. Thanks in advance.

email address :aobautista@bhpi.com.ph

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources