Edit Data Previously Entered Through Userform

[cmoore24]

I've tried posting here before and looking all through the internet but can't find a solution, mainly because I cannot upload my workbook. I can only post my code, which is shown below. What I have right now is a userform that opens when double clicking a persons name. In the userform, the user selects an event from a combo box, enters the date that they arrive (mm/dd/yyyy) in a text box and enters the date they leave (mm/dd/yyyy) in a text box. When they click SAVE, the block of days they have entered will be highlighted in a color based on the event (red for event1, blue for event 2, etc.). What I would like to do is be able to double click any one of the days in that block to open the userform with the data that the user entered, be able to edit it, and overwrite the incorrect info (for example someone selects event1 from 09/01/2015 - 09/05/2015, but then realizes they will be gone to event1 from 09/01/2015 - 09/08/2015 so by double clicking on one of the days in the original range, the userform opens with the data already entered but can be changed to the updated dates and the changes made will be shown on the calendar). Please someone help, this is really the only thing I have left to do with this worksheet but I can't find anyone that can understand what I need without seeing the workbook.

Please Login or Register  to view this content.

[excelliot]

use following code in userform

Please Login or Register  to view this content.

And call macro using following code:

Please Login or Register  to view this content.

To get existing values in form select range for which you need to change dates, & call userform & execute range edit..

Check attachment for clarity.. Select range H8 to K8 & click on blue button to call macro, you can call macro from worksheet change event, sheet before double click method too..

Cheers!!

[cmoore24]

Thank you so much it worked perfectly. I replaced the userform you had with the one I've been using but it does the same thing. I really appreciate it.