Get Data from a cell into TextBox1 in Userform?

Hello Excellers,

I am struggling with making the userform able to get the data from a cell in a worksheet and pass it to textbox1 when it is opened. The data from the cell is refreshed every time the workbook opens (using external data: web source data).

The code I wrote on the userform is:

Formula:

Private Sub StoreVerse()

    Dim rngText1 As Range

    Set rngText1 = Sheets("Apr").Range("D3")

    TextBox1.Text = rngText1.Value

    'Application.Wait (Now + TimeValue("0:00:10")), "UnloadVerseForm"

End Sub

What am I writing erroneously?

Let me know! Thanks!!!