i need a excell code

[unixisgood]

hi all,
I need a code and maybe it's gonna be really easy to write for u but i am new to find out how i am gonna do with excell.I have to do this with excell because all i have is that here.
I have sheets in a called by diferent names in a worksheet and they have data like ;

sheet1 is like
A B
1 yellow 123456789
2 blue 987654321
3 pink 456789123

sheet 2 is like
A B
1 black 965231544
2 white 654841313
3 purple 548746564

All i need is
first ;
1- show me a userform to write a number i am looking for as an input
2- when i write any number in the user form to search ,it should search all the excell workbook(included all sheets) and find the name which has my number .

3- And show me to number with name in the msgbox .


the text i want to see is in a msgbox or in a something diferent thing is like;

the white field has the number "654841313"


Thanks for Any help

 

[TonyJollans]

What exactly are you trying to do here? This seems like a rather pointless exercise on a badly designed workbook.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[