Pop up text box deleting text in linked cell

[excelnat]

Hi, Hopefully this is a quick one. I have a pop up UserForm1 which contains 2 text boxes which are linked to B33 and D33 each of Sheet1. So the UserForm1 appears and the contents of these cells are displayed. B33 and D33 are formulas and the text boxes show the results of those formulas, which is what I want. However, when I click OK to close the UserForm1, the text boxes overwrite the contents of B33 and D33 with the results of the formula only, so no formula. Can anyone tell me how to get around this? I'm using 'Unload UserForm1' to close it if that's a problem, but I don't know what else to use if it is? Thanks, EXCELNAT.

 

[FormR]

Hi, If I understand correctly - you need to remove the link from the text boxes and instead populate them using the forms Initialize event.

For example:

Private Sub UserForm_Initialize()
Me.TextBox1.Value = Sheets("Sheet1").Range("B33").Value
Me.TextBox2.Value = Sheets("Sheet1").Range("D33").Value
End Sub

 

[excelnat]

WOW! Thank you so much!! Perfect!