This relates back to my previous enquiry regarding how to update ListBox items from a range of dates. This was answered successfully by EE expert dlmille
I should have asked the obvious question...how do I determine which of the items in the ListBox was selected by the user ? Also, can I test to ensure they have actually selected an item ?
I want to pass the value (a date) of the selected item to another procedure (a button click) on the same sheet which builds a filename using this date. I've created this button click procedure but not sure if I can pass the date to this procedure.