UserForm-Insert value from diff worksheet into text box upon initi

[Guest]

How do you code UserForm_Initilize() to copy the value in a specific cell in
a different worksheet (within the same workbook but not on the same worksheet
that the UserForm is on) into the textbox on the UserForm?

Thanks in advance.

 

[Susan]

in the initialize coding, put

me.txtboxname.value=worksheets("name").range("area").value

fix the appropriate names with your own.
susan

 

[Guest]

Thanks Susan. This sort of worked. When I click on the command button to
open the form it does not populate the text box; but if I click on the Clear
command button (which calls UserForm_Initialize) then the text box is
populated.

 

[Guest]

Disregard. I got it to work. Thanks again.

Thanks Susan. This sort of worked. When I click on the command button to
open the form it does not populate the text box; but if I click on the Clear
command button (which calls UserForm_Initialize) then the text box is
populated.