Userform Textbox change event issue

Hello all,

I am not sure if there is a way around this but hear me out.

I have a userform that has a text box. I have a _change event associated with that text box that based on the input in that text box populates other text boxes on the form. Now its almost fully functional... if i open the userform and type 1 in the binbox it updates all the text boxes... if i press the backspace it empties all the below text boxes however if i highlight the text in binbox and change the 1 to a 2 nothing updates... its like highlighting the value and changing it doesnt trigger the _change event.... has anyone else seen this? is there a way around it other than just dont highlight the text and change it? Also if i try to type 10 and 10 doesnt exist yet all the boxes should be empty but they stay populated with items from bin 1... but if i type a number where the first number doesnt exist yet it clears the boxes.

I am just trying to build a down and dirty inventory system for my side gig.

Please Login or Register  to view this content.