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)?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.