So I am currently working on a Userform that has two list boxes with the row source set to a list of values with TODAY Function. When I enter in the information it will put in the first date in just fine but will clear the cell where the second date is suppose to go. I know it has to do something with the Today function because if i just use a list of just dates it works fine. Is there something else I need to do? Here is the code so far.
and here is where I set the row source![]()
Please Login or Register to view this content.
The list is just TODAY(), TODAY()+1, etc 30 days worth![]()
Please Login or Register to view this content.
If there is a better way of doing this I would really appreciate the help
Bookmarks