Have Userform Recall Cell Values when form is reopened

I have a spreadsheet where I created a userform to insert multiple review dates in one cell. Right now the form opens when you double click on cells in column B or C. I often place one review date into the cell and then go back and add a second or third review weeks later. Because of this I need the userform to populate with the existing information in the cell when you open the form to add a second or third review. Does anyone know how this can be done?

Userform_Click_TEST.xlsmUserform_Click_TEST.xlsmI also noticed that the userform inserts spaces for all 4 reviews in the cell even if I only check the first review. I'd also like to have the form delete these blank spaces if the reviews aren't entered. Any help is appreciated.

Try this...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks, that work perfect. For some reason I had to take "Trim" out of this area:
Me.Controls("TB" & i + 1).Value = Trim(Split(d(i), ":")(1))

After that it worked. Do you know if there's a comand that when you clicked on the second review check box it would cross out the date in the first review? I want to keep the date there, but it would be helpfull to cross it out. Thanks again for the help!

Originally Posted by kicker850

Thanks, that work perfect. For some reason I had to take "Trim" out of this area:
Me.Controls("TB" & i + 1).Value = Trim(Split(d(i), ":")(1))

After that it worked. Do you know if there's a comand that when you clicked on the second review check box it would cross out the date in the first review? I want to keep the date there, but it would be helpfull to cross it out. Thanks again for the help!

On the userform, you would set the previous textbox's font property e.g. TB1.Font.Strickthrough = True, when you click on the next Checkbox. I'll let you work that out.

On the worksheet, this will strikethrough the previous dates within the cell when you click the Add button

Please Login or Register  to view this content.

Thanks again for all the help. I have one more questions about adding a ComboBox to this. I replaced the label with a ComboBox so I’m trying to get the form to recall the values in the combobox and text box every time it's reopened. See attached for example. After trying to modify the code I get an error. Do you know how to split the text so the combobox and textbox show already inserted data?