Hi all,

I have a userform with a textbox, combobox and a command button. The textbox is already locked in the properties.

Item 1 of the combobox will do .find operation and displays the result in the textbox upon clicking the button.
Item 2 of the combobox will do autofilter operation, store the filtered data in an arrary and display the array data in the textbox when the button clicked.

Both operations display result in the textbox just fine. I wanted the text in the textbox to be locked so that no changes can be made on the display result.
The problem is, text result of the autofilter disappears when mouse click in textbox. But this doesnt happen for the .find operation.


What may the cause of this problem? Could anyone help me with this?

Thanks in advance.