Is there a way to assign all digits of a number entered in a userform textbox to a variable?

[bhat88]

I hope the title is not confusing. Well, let me explain.

I have a userform with a textbox. I assign the user-entered value to a variable like this:

Dim balance as Long
balance = UserForm1.TextBox1.Value

Now if user enters 1234 in the textbox, first 1 gets stored in 'balance' then 2, then 3 and then 4. I want 1234 to be stored in 'balance' at a time which is required for looping up next my code. Is there a way?

 

[ranman256]

Why do you need a variable? The TEXTBOX is the variable.
If the user enters 1234 into textbox1, then
textbox1.value will be 1234.

I cant see from your example but you may have this code under CHANGE event. dont put it there. Heck, dont use the variable ...the box is the variable.

 

[bhat88]

Hi, thank you for the quick help. I agree I can use the textbox as the variable but just for the ease, I am assigning it to a variable which I am going to use many times in my code. Anyway, my point is that 1234 is getting stored digit-by-digit. A simple code example:


Dim balance as Int
balance = UserForm1.TextBox1.Value
MsgBox balance

As soon as user enter 1, the message box pops-up 1. Close it and enter 2, it pops-up 12 and so on. I want 1234 to be popped-up at once.

 

[Norie]

Sounds like you are using the textbox's Change event, try another event, for example Exit.