herpasymplex10
Board Regular
- Joined
- May 26, 2005
- Messages
- 224
Greetings!
I'm helping a friend with a spreadsheet and my brain is fried.
Looking for some general advice.
Sheet has a userform with two comboboxes.
One with a list of jobs
and one with a list of people (to assign those jobs)
I'd like to create something that won't allow her to click on the command button
to add the data to the sheet if the following happens:
Trying to assign a job that is already taken to someone
and/or
Assigning a job to someone who doesn't like that job
(that information is stored on the spreadsheet)
Thoughts?
The second one I think I can figure out.
The first one I'm stuck on
I'm helping a friend with a spreadsheet and my brain is fried.
Looking for some general advice.
Sheet has a userform with two comboboxes.
One with a list of jobs
and one with a list of people (to assign those jobs)
I'd like to create something that won't allow her to click on the command button
to add the data to the sheet if the following happens:
Trying to assign a job that is already taken to someone
and/or
Assigning a job to someone who doesn't like that job
(that information is stored on the spreadsheet)
Thoughts?
The second one I think I can figure out.
The first one I'm stuck on
