Userform question (Excel 2007)

[roscoe]

Up to now I've done everything with worksheet cells and spinners/buttons/etc on the sheet itself. Now I actually have to suck it up and try and learn how to use a userform.

Is it possible to display a custom formatted Excel serial date value as text on the form and use spin buttons to change the value (i.e. buttons for week, day, hour, minute) and have the text change to reflect the spin button pushes? I'll need to do this for two different dates...how easy would it to be to use the same spin buttons but use a radio button or something to designate which time value I'm changing?

Thanks

 

[Smitty]

I'd use the Date/Time Control Picker.

See Martin Green's tutorial here.

HTH,

 

[roscoe]

That's very interesting, I hadn't seen that before. Problem is I see no means to enter time and that's a necessity. Plus I already have spinner code that rolls time codes quickly. They currently work on a cell. I just need to find a way to make it work in a form. I also need to figure out how to edit existing dates and times.

Thanks