Set focus on textbox and write incremental value with every button click

Hi,

I have 7 textboxes on a userform and a button. Button suppose to place an incremental value to the textbox with every click. But as I mentioned, there are 7 textboxes. The aim is:

• User selcts ANY of 7 textboxes
• User clicks the button
• The value in a textbox, which was selected, changes to 1
• With every further click the value in the same textbox increases by 1

How do I go about it?

Thanks in advance for your priceless help!

Code below from the example attached will do this.

Please Login or Register  to view this content.

Note, I've set the command button's TakeFocusOnClick property to FALSE

BSB

Ah, learning something every day... I didn't know how to keep focus on the textbox while clicking the button. Brilliant, solved!

Glad I could help in your learning

BSB