Macro to compare value that's entered in text box VS Column A of all available spreadsheet

[shonre@gmail.com]

Here is what i have tried. And i am stuck at this for weeks now. I have tried many solutions posted in many threads but none of them is working for me.
This is what i want

value entered in textbox = 12345678

i want the value entered from the active worksheet to be compared across all worksheet only for column A. Please help me. Advance thanks to my saviour

Please Login or Register  to view this content.

[ragulduy]

I'm not sure I understand what you want, as your code does something quite different to what you requested but maybe something like:

Please Login or Register  to view this content.

[shonre@gmail.com]

Thank you very much. not very accurate of what i want but i was able to manipulate the subfunction to my needs.

[ragulduy]

Hi - glad you were able to get a solution.

Perhaps you coudl share what you came up with to help any other users who look at this thread for an answer?

Also - can you mark the thread as solved (click thread tools -> mark as solved)