Issues encountered in VBA programming
Thread Content
In VBA, how can the value of TextBook be assigned to a spinbutton, so that it changes as the value of TextBook changes? It’s urgent; I hope experts can give me some advice! Thank you! To solve this problem, I wrote the following program myself, but it doesn’t work. Could everyone please take a look and see if the program is correct? Thank you! Private Sub TextBox1_Change() Dim NewVal As Integer NewVal = Val(TextBox1.Text) If NewVal >= SpinButton1.Min And _ NewVal
The code should be written under Form, I guess. It seems the event code for SpinButton1 should also be written as Private Sub SpinButton1_Change() TextBox1 = SpinButton1.Value End Sub
I just tried it, and indeed, half of it is missing. Thank you! I had placed this line in another location originally; haha. But you’re missing something – it should be Private Sub SpinButton1_Change() TextBox1.Text = SpinButton1.Value End Sub
Actually, the Text property of the TextBox control is default; it makes no difference whether it is specified or not. But for clarity, it’s better to include it