I am currently creating a databasse to track OT hours for my department. I want to create a combo box to select the number of hours to be posted so the hours are consistant. Some users might enter 1.30 for an hour and a half instead of 1.5. So I want to create a combo box that has the hours in the following format: 1.0, 1.25, 1.50, 1.75. 2.0 and son on. Is there an easy way in somekind of VBA coding to achieve this or o I have to build a list?
Looking forward to your responses.