So I have a userform with TextBox1, the user will manually write a number and I need to display data related to that number in the same userform right after the number is written.
I would like to have that appear in a label right below the textbox so that it doesn't seem editable
So, the number would have to be searched in sheet2, column A and needs to pull data from column B (date), C (action)and D (quantity), the thing is that it will appear in about 4 or 5 rows, so I need each row to be displayed, something like this:
06/10/2016 operation-A 10,000
06/11/2016 operation-B 5,000
06/12/2016 operation-B 5,000
06/12/2016 operation-C 5,000
I'd really appreciate your help with this,