I need to have a TextBox (or ComboBox) on a user form that has an
associated SpinButteon be able to show a time range of 0 to 8:00 in 15
minute increments (step of .010417).

I'm thinking that a ComboBox setting the List source to an array and
using the SpinButton to move up or down the array would be the best/
simplest.

The data from the UserForm will eventually be copied into a cell that
will be included in a mathmatical function; so I need it (the data) to
not be string but the numerical value (0 - .333344). Visually it
needs to be formatted [h}:mm both in the dropdown and on the form.

More details can be provided either OnGroup or in email if needed/
wanted.

Thanks