Userform opened by double click containing data from worksheet

Hi

I have a userform which opens when a specific cell is double clicked on a worksheet. This userform has two textboxes which bring up information from another part of the worksheet. My code is below is written on the worksheet itself. The userform opens upon double clicking but the data retrieved by the userform is for the previous double click. For example the first time I double-click on C9 both boxes are blank. The next time I click on Cell C9 it correctly returns values in cells C109 and C209. If I then clicked on Cell D9, it would then return the values I would have expected for C9.

Please can you advise if I am missing some code or if the with userform instructions are in the wrong place?

Private Sub Worksheet_beforedoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("C8:CL100")) Is Nothing Then
Marketinfo.Show
With Marketinfo
.txtAddinfo = Target.Offset(200, 0).Value
.txtSSI = Target.Offset(100, 0).Value
End With
Cancel = True
End If
End Sub

Thanks very much

Hi Norie

Thanks for your response, sorry about the coding issue, I will take note for future. I updated the code but it still has the same issue - do you have any other suggestions?

Please Login or Register  to view this content.

It's a work project so I am unable to upload as it contains sensitive info...sorry.

I have a Close button on the userform which hides the form when clicked

Please Login or Register  to view this content.

I tried chaning the close button to "Unload Me" but that still does not fix the problem.

Thanks for your continued suggestions though do you have any other theories?

Do I also need to change "Marketinfo.show" to something like "Load Market info"?

Ok I've created a dummy of what I have. I have the same issue on the dummy workbook as I do on the original.

Thanks!

Excellent that works! Thank you very much