View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RMF RMF is offline
external usenet poster
 
Posts: 6
Default Inserting time via DTpicker but per 15 min i/o per min

Dear users,

I have made a userform with a DTpicker that I use to insert time into a
cell. If I run the macro and open the userform I can enter the time but
besides hours I have to scroll through the minutes to set the time on hh:15,
hh:30, hh:45 and hh:59. I only need to use these 4 options. I dont have to be
able to select hh:34 or hh:07. I just need 15 min. intervals.

Any ideas on how to do this? I am not such a code expert, so all help is
appreciated!

R