Error 91

[sich48]

Hi there, When using the attached code, I get an Error 91 when closing/unloading the userform. The code runs fine and the value in the textbox is increased/decreased as intended. The error shows only after closing the form.

Private Sub spnButton1_Change()
    Me.TextBox1.Value = Me.spnButton1.Value
End Sub

Private Sub UserForm_Initialize()
    Me.TextBox2.Value = 350
    Me.spnButton1.Value = Me.TextBox2.Value
    Me.Show
End Sub

[Logit]

.
Place this line in a Sub all it's own : Me.Show

Except, change the ME to the actual UserForm name.

[sich48]

Thank you, Logit. It's solved. I knew it would be an easy one but I couldn't figure it out.

[Logit]

.
You are welcome.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)