humboldtguy,
Please don't quote whole threads as it clutters up the post and isn't necessary. If needed, just reference the specific portion of the thread using the quote tags. It will keep the thread cleaner.
First, I don't why see you chose to use a lot of unnecessary For loops to add items to the controls while making reference to named ranges. You can simply enter the named range in the RowSource property of the control and will end up with less code to write and manage.
For the the combo box in the initialize event, add this line (must be on its own line and not inside the For loop).
I have Excel 2003 on this PC and have to use the Office 2007 conversion pack to open your file. I get an error when displaying your form and can only attribute this to the conversion. It errors on the line formatting the date value of the combo box. I had no issues with this per the sample workbook I had created, so the code is valid.
In your "Date" range, unless you need the time component, I would use TODAY(), which does not include the time, instead of NOW() which does - seeing as your form is designed to select time entries separately.
Bookmarks