On Button Press Send Value to Selected/Active TextBox?

Just an experiment / learning.

I have several TextBoxes on the screen (in a userform). I want to be able to click in one and then click Button and then the Button would send value to the TextBox that is active.

Very simple but yes, I am that new. I know how to pass the variable to a specific Textbox just not the focused one.

Please Login or Register  to view this content.

Thanks in advance!

Is this correct?

Please Login or Register  to view this content.

Both seem to work, thanks!

Actually, earlier I tried

Please Login or Register  to view this content.

And it was simple and worked, but now that is throwing an error Runtime 438, object doesn't support this property or method.

Trying your method Deamo but I don't know how to implement it.

Edit:
Figure it out, thanks Deamo, am curious why my other method worked, then didn't later??

So, This works great, but I have 50 buttons that I have to duplicate the below code

Please Login or Register  to view this content.

Is there a way to condense that without having to repeat the above 50 times (I have 50 buttons that return color values so for each color value I have to duplicate the above)

They are all buttons named "Color1" "Color2" "Color50" etc but there are some numbers missing so it is not 1-50. The value to be given matches the number on the button, so Color50 would send value 50.

Thanks again

I noticed that too.. how to pick up which control has the focus prior to a mouse click (aside from using the activate event of the form) is eluding me.

Norrie mentioned in this thread about using a class to handle multiple combobox change events, which may work here too - I have no experience with this, yet.

Edit: turns out you can use the Enter event of the textboxes, as that's triggered when the form is loaded

Originally Posted by Deamo

I noticed that too.. how to pick up which control has the focus prior to a mouse click (aside from using the activate event of the form) is eluding me.

Norrie mentioned in this thread about using a class to handle multiple combobox change events, which may work here too - I have no experience with this, yet.

Edit: turns out you can use the Enter event of the textboxes, as that's triggered when the form is loaded

I tried that just now but getting the same error, must have implemented it wrong?

Oh I got it, I had tested the one I didn't change

Please Login or Register  to view this content.

Works perfect, thanks!

Now I need to streamline this some how so I don't have to post the code 50 times.

Please Login or Register  to view this content.

That's for 1 button and there are approximately 5



Another question about this same thing, when clicking the button the focus is lost (no focus anywhere on form) and I have to Tab back into it. Anyway to keep focus on the box (so that I can have it go to the next box)
Unsure why focus is being lost.