Userform populated back from cells

I'm using this code to populate cells in a a range from a userform:

Please Login or Register  to view this content.

Question: how would I adapt this code so that when the first cell in the range of cells originally populated by the userform is clicked, that the userform appears with the same content in the userform textboxes. The idea is to be able to "reuse" the form to adjust content in the cells without having to open up a new userform and edit each text box. Is there some way to do this?

Thanks for your help! David

Hi Norrie, I tried replacing the original code with what you provided. I presume that's what you meant by "reverse"? Unfortunately it doesn't work. Any other thoughts? I do have this sheet code, which trigger the userform to populate the cells:

Please Login or Register  to view this content.

Thanks for your help. David

Thanks BSB, I already have this code working in the sheet:
[CODE][/Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(Target, Range("B5:B7,F5:F7, J5:J7, N5:N7, R5:R7")) Is Nothing Then

ASSIGNMENT_FORM.Show
End If
End Sub

CODE]

But thanks for thinking of this because of course the useform wouldn't work without it! Much appreciated. David

Originally Posted by dgibney

Hi Norrie, I tried replacing the original code with what you provided. I presume that's what you meant by "reverse"? Unfortunately it doesn't work. Any other thoughts?

If you could give us more of an idea of the layout of your workbook, or even better attach it to this thread, then we can help you with the code to repopulate the userform.

BSB

Sorry for the late response, I was gone for a few days. I've attached the file, my attempt at making the userform info populate from the cells to the userform, and vice versa. It's not quite there.... Hopefully, it's an easy fix.

Thanks again. David

See attached for one method.

I've added some Public string variables to a module that are used to store the details pertaining to the task you click on.
Then I've added a UserForm initialize event that checks if these strings are empty or not. If not the the form will be populated, if empty then the form opens in the blank state you had already set up.

Hope that helps point you in the right direction.

BSB

This is perfect! Just what I needed. Thanks for your help, it 's very much appreciated.