userform value
 

I have a userform that when is shown when the user clicks a button. When the
userforms opens I want to show a number in a textfield. However that fails
and the field shows nothing. The number is found in a cell and the number is
then read in to a variable that is to be shown in the userform. Pls help me
with this problem.

Private Sub UserForm1_Initialize()
Set rngErrorMarginCell = Range("d5")
dblErrorMarginal = rngErrorMarginCell.Value
TextBox1.Text = dblErrorMarginal
End Sub

userform value
 

Try qualifying with the worksheet name

Set rngErrorMarginCell =Worksheets("Sheet1").Range("d5")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arne Hegefors" wrote in message
...
I have a userform that when is shown when the user clicks a button. When
the
userforms opens I want to show a number in a textfield. However that fails
and the field shows nothing. The number is found in a cell and the number
is
then read in to a variable that is to be shown in the userform. Pls help
me
with this problem.

Private Sub UserForm1_Initialize()
Set rngErrorMarginCell = Range("d5")
dblErrorMarginal = rngErrorMarginCell.Value
TextBox1.Text = dblErrorMarginal
End Sub