Hi,
I am creating excel database (input via Userform) where i am facing two issues. could someone help me on below:
1. I am entering data through form and it is saving in sheet2 . The data contains numbers, date, text etc. But the numbers are saving in text format which is difficult for excel calculations.
2. Day + weeks = Day (example: 06/29/2017 (any day) + 2 weeks (14 days) = 07/13/2017)
in form, there is date picker and combo box to select the weeks. if we select date and weeks then in text box it should display the expected date (07/13/2017)
I am creating excel database (input via Userform) where i am facing two issues. could someone help me on below:
1. I am entering data through form and it is saving in sheet2 . The data contains numbers, date, text etc. But the numbers are saving in text format which is difficult for excel calculations.
2. Day + weeks = Day (example: 06/29/2017 (any day) + 2 weeks (14 days) = 07/13/2017)
in form, there is date picker and combo box to select the weeks. if we select date and weeks then in text box it should display the expected date (07/13/2017)