Defining Cells location Using DTPicker and 1 more issue

[toshlad]

Dear forum,

Got some great assistance a few days ago. Here's my new problem:-

I have uploaded my sheet and current VB code. Here's what I'm trying to do

My engineers have to replace paper rolls at various locations, they have to record this. Each location has an upper and lower and they might have to replace both of these.
They have to record the replacement using the date, the location and if it's Upper, lower or both.

I have written some VB code to do this and now I'm stuck. I want the engineer to be able to select the location, the lane number, if it's Upper or lower or both, the date replaced and their name.

When they click "Add Entry" I would like the letter U or L or B to be added to the correct location using the date and lane number and the cell fill to be coloured to match their initials. Not asking for much am I? lol

Many thanks in advance

[Mumps1]

Try the attached file. Click the "Input Data" button. How do you decide what colour is assigned to which initials?

[toshlad]

Colours are just different for each initial doesn’t mater really just looking for a solution that assigns a colour to the cell so I can tell which engineers are doing to work :-)

[Mumps1]

Try the attached file. I've added the names with the corresponding colours for your reference.

[toshlad]

Mumps1, Many thanks for the exceptional help. I won't be able to try thins until Monday when I'm back in work but thanks so much again.

[Mumps1]

My pleasure.

[toshlad]

Mumps1 this works perfectly :-) Many many thanks

[Mumps1]

You are very welcome.