Hello Everyone,

I am currently working on a user form that will keep track of products going into storage. I have a ComboBox with a selection of end storage years depending on the product e.g 3 years, 5 years etc. A storage date is also given as the day the form is filled out.

When the data is put into an assigned excel sheet I want the End date to be shown and not the number of years for it to be stored, which is the code I have now. The following is my code for the OK button.

Any help really appreciated.

Regards,

Orla 

Please Login or Register  to view this content.