Editing Userform Data

I have a userform that highlights a block of dates on a calendar in a certain color based on the event that the user chooses. I want to figure out a way to double click on the block of dates that was highlighted and edit them (in a case that someone accidentally enters the wrong dates they can double click the highlighted cells and the userform reopens and they can enter the correct dates and when they click save the change will be updated on the sheet). My current code is as follows:

Please Login or Register  to view this content.

please attach a workbook with the working userform like this it will be very hard to give advice

Originally Posted by gmr4evr1

How about this...Double click any cell and the userform will show.

Please Login or Register  to view this content.

Opening the userform from any cell is only useful if I can edit the data that was entered in via the userform.

Originally Posted by LordLoki

please attach a workbook with the working userform like this it will be very hard to give advice

I cannot attach the workbook it contains sensitive material. I know its hard to give advice without looking at it first hand, but any help or thoughts are appreciated and I can do trial and error from there. Thanks.

Originally Posted by cmoore24

Opening the userform from any cell is only useful if I can edit the data that was entered in via the userform.

Thats what i thought :D
But to answer that is much easier with the workbook :D
Can you not just make a copy and make some mocup data?
Its just that the userform part is a bit hard to imagine when you not have it in front if you

Originally Posted by LordLoki

Thats what i thought :D
But to answer that is much easier with the workbook :D

I know and I'm sorry, but to even post a workbook with dummy info would take more time to create than what I have to try and get done what I need to. Is there some kind of general function where I can edit data that's already entered?

no there is no such thing.
Thats why i would like to see how you write the Data exactly to see how to approach your problem.
you would need to write that by your self. here is what i do in a workbook that does something similiar.

Please Login or Register  to view this content.

planner (2).jpg

Not sure if this will help but its a screen pic of what my empty sheet would look like. Down column A from row 11 through 16 are events that are blocked off in different colors (done manually). Down column A from row 17 down are a list of names. When a name is double clicked, the userform opens. The userform includes a combo box with a list of the events to choose from, a text box to enter the start date of someones trip and a text box to enter the end of someones trip. When this information is entered, the colored blocks you see on the right of column A are automatically created to signify that the person you clicked on is at that event during those dates. Now once that is created, I just need a way to double click on one of those colored blocks (for example click the red block on row 19 and be able to change the dates). If this isn't enough to go on, then thanks anyway for your help I appreciate you being patient with me.