PDA

View Full Version : Drop down list plus text box



rdavid87
12-08-2013, 03:50 AM
My problem is pretty complicated (at least for me). The concept is that I would like to choose the date from calendar and also the quarter hour and show the value in a text box.
I also attached an example file.

EirikDaude
12-08-2013, 08:18 AM
For picking dates, I've used the calendar control described on this site: https://sites.google.com/site/e90e50/calendar-control-class
For picking the time, I guess you could just make a dropdown-list using the data in column B as the source?

If you're not going to accept arbitrary dates as the input, but only the values found in column A, I guess the easiest way to do that would be to create a new list from the cells containing values in that column?

To find the correct value you'd search column A for the date, and then search in the range defined as something like Range(foundInCell.Offset(0,1), foundInCell.Offset(95,1)) for the correct time-interval (where foundInCell is the cell you found the date in)?