In a Module:
In Userform1:Public g1 As Double Sub Sim() g1 = 5 End Sub
IF the goal was to load controls before showing, I would:Private Sub CommandButton1_Click() Sim TextBox1 = g1 End Sub
Sub Sim2() Sim Load UserForm1 UserForm1.TextBox1 = g1 UserForm1.Show End Sub