SpinButton freezer

[BrianReis]

Hello, i have been working with VBA in Solidworks but i believe my question still applies

I started using a spinbutton in my form to add a value in the textBox, so far so good, had no problems
Everything runs smothly in my form until i press the spin button, because when i do i cant press anything else from the form (close button, tab button, anyother button that is not the spin button.)
The only way to make the form work again is to select a textBox and then i am free from the claws of the SpinButton

Does anyone know why this happens?
Its a pain for the user to have to allways press a box (wich i wanted to disable) in order to continue

Thanks in advanced guys

 

[Jeffrey Mahoney]

That shouldn't be the case. Do you have some code to post showing what happens when you press the spin button. Maybe your code is causing an event in the textbox and looping endlessly.

Jeff

 

[BrianReis]

I can put the code here tomorrow
Doesnt seem like a endless loop cause when i click on a textbox i would be able to do everything again
Over the day i managed to work things out. Basically, when i click the spinbutton i hide my form, run the code, and then when its done i show the form again and it all works good

 

[BrianReis]

That shouldn't be the case. Do you have some code to post showing what happens when you press the spin button. Maybe your code is causing an event in the textbox and looping endlessly.

Jeff

This is what i put inside:

Private Sub SpinComp_Change()
txtComp.Text = SpinComp.value
Comp = txtComp.Text
DesenhaVectores
End Sub

Desenhavetores is a function that will draw lines in the solidworks
It worked but it was blocking my form after running (if i run the desenhavetores outside this spinbutton the form does not get blocked)


This is how i managed to resolve the situation

Private Sub SpinComp_Change()
Me.Hide


txtComp.Text = SpinComp.value
Comp = txtComp.Text
DesenhaVectores


Me.Show vbModeless
End Sub

This way works and the form doesnt get blocked but it seems like a bad way to do it


Thank you for your help in advanced