New to this forum, looking for some assistance.

I have a user form to enter truck order information. In a text box I enter the order #,
I want to be able to enter order # 1 up to order # 10

When I select add order to daily order I want the information added to worksheet tab daily order in the correct order # row.

I also would like the row background color to red indicating if order was received after 2:00 pm.

Thanks for any help on this