Help with vba for userforms

Hello All,

I am working on a large project, and a major part will be allowing others to add/edit data on a worksheet. I am a VBA lightweight, but have been using this forum to self teach, but I am feeling lost on the User Forms. I have created the form, and have all my fields in, but I am trying to understand what code is required to make it work. I have played with som eonline examples and can get those to work, but am unable to translate it into something that suits my project.

The idea is that they can launch the form to add or edit a job to the jobs list. In the Add tab they can add a new line ot the jobs list, in the edit tab they can enter a job and it will call up the information and allow them to edit and save the existing info. I will include a workbook that has all the data needed for the form, and have put in notes on what is what in the document. More than a solution, what I am hoping for is something with notes explaining what each part is referring to, so that I can learn how rather than just ask someone else to do it.

If you need any more details I will be eager to answer. Thanks for any help that can be provided.

Dan

what do you mean by :

quote:

This sheet is used to provide the options for the Job Type field. I need combo box to show the Job Type (light orange) on the left and the matching description. When using Edit or Add I would like it to write only the Job Type on the job codes data sheet. And would like the data in the job type field to have to match the options in Job Type. The second set of values (light purple) are used so when we copy in the info for the new week, if there is no job match it can provide a starting point for the user.

end quote


your job type on the two sheets dont match, so what is the list that should drive the drop down menu???

Hi Jarko, thanks for the reply. Sorry about the poor wording, I tried to explain what i needed, but after a good sleep and fresh eyes its a bit of wordvomit I think.

Basically, when the user enters the job code into the form, i want it to trigger an event where it searches in the Job Codes Data sheet and if it's found alerts the user job already exists. If not found, then it searches in the Data Current Week sheet for that code and lines up the info into the other fields. Since my users sometimes have to create a job days before getting a job code, it allows them to enter the job with a generic placeholder, or if they have the info or it is different than what is there, they can overwrite it.

Dan