Combobox Time Entry results in wrong calculations

Hi,

I currently have a userform where the user selects a series of time values from a combo box drop down:

Please Login or Register  to view this content.

Timelist refers to the names range I have for the times that can be selected.

I then use the following code to display the times correctly in the combo box instead of numerical values:

Please Login or Register  to view this content.

The problem I am having is that once the values are entered and the cells populated after submission, cells referring to the newly created time cells are not calculating properly. I'm not sure if this a formatting issue or a problem with my formulas.

Thanks!

M

Yea I used this: http://www.excel-pratique.com/en/vba...ate_format.php

I tried with mm and it wasn't working either.

I have a separate set of checkboxes on the userform where the user can select days of the week to apply the entered time schedule:

Please Login or Register  to view this content.

This is repeated for each day of the week

Originally Posted by TMS

I would think you'd need something like:

Please Login or Register  to view this content.

Regards, TMS

This gives me a type mismatch error

Changed my combobox code to:

Please Login or Register  to view this content.

Based on this information http://www.mrexcel.com/forum/excel-q...-combobox.html
The formulas referencing these cells still aren't calculating though. Sometimes if I double click on the cell and click somewhere else on the spreadsheet the formula will calculate. So weird........

I think it has something to do with the cell formatting....

HAHA! Great Success.

https://www.youtube.com/watch?v=IlG5sTV50Yw

Fixed it by adding .Value, you were correct!

Please Login or Register  to view this content.

Thanks!