UserForm Help

[kgbo]

Hello,

I am the process of creating a user form. On the form I have a combobox and two textboxes. The combobox is prepopulated with a range from a spreadsheet. The first textbox is formatted for the user to enter a date (mm/dd/yyyy) and the second is to enter the time (HH:MM AM/PM).

On the spreadsheet where the combox is referencing, I have the date field already typed in.

Ultimately, I would like the user to select the Customer ID# from the combobox (12345). Then, type in the date (5/5/2014). Then type in the time of the visit (1:00 PM). Then click the Add Button.

How do I make it so that when the user clicks add, it will search the spreadsheet for the Customer's ID (Column A) and then the date (Column B) and fill in a specific cell for the time of the visit (Column C)?

[p24leclerc]

Please attached a sample workbook so we can work with your actual workbook structure.
Thanks