Locked textbox clears text when command button clicked.

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.

Use

Please Login or Register  to view this content.

It will prevent the user entering it.
Also make sure you do not have any Textbox1 enter scripts that may be clearing it.

i tried to use

Please Login or Register  to view this content.

i dont want to disable the textbox as it will make the text turn grey colour. Or is there a way to change the text colour of the disable textbox into black?

Could anyone help me with this?

I've been trying to solve this problem for few days. All the logic works fine but the text in the textbox disappears on mouse click? I already locked the textbox in the properties? Why did this happened? Is there anything wrong with my logic/codes?