Category: Excel Data Validation

Excel Combo Box Number Problem 3

Excel Combo Box Number Problem

Let’s file today’s blog’s post under “Obscure Excel Problems”.  I heard from Y.B., who was using my Data Validation Combo Box, and numbers were being entered as text. The code is supposed to fix...

timeentry23a 4

Drop Down Hours and Minutes

Last week, someone asked me how to create drop down lists for hours and minutes, and also control the total time that was entered. Production time and Defect time would be entered, and Defect...