vba to display lookup results in a msg box

[BORUCH]

HI

I need a Vba that does the following.

In a sheet called "customer info" i have two columns customer number, and the customers phone number.

in another sheet i have the customer number, and other info for that customer in a pivot table format (which doesn't matter for this question)

i would like that if i select a customer number and hit a command button it should displays that select customer number phone number in a MSG box

Like vlookup results in a MSG box

Thanks

[:) Sixthsense :)]

Post your sample workbook so that we can give exact code

[sintek]

Hi BORUCH

Something like this...

[BORUCH]

Hi BORUCH

Something like this...

YES SOMETHING LIKE THIS

but i need a few thing changed

# it should be selection not VLookup(Range("D2")

#2 i would like to have the phone number in bold lettering (more customized like font etc.)

#3 if possible it should close after 30 seconds

maybe a user form is a better option

thanks

[sintek]

See Post no 2 from sixthsense

This will enable us to give exact code and not make assumptions!

[BORUCH]

See Post no 2 from sixthsense

This will enable us to give exact code and not make assumptions!

the sample workbook is a great example

[sintek]

Play around with this...

Edit...Displays for 10 seconds then closes....Edit font as per requirement
Not sure what you mean by

# it should be selection not VLookup(Range("D2")

[BORUCH]

i mean to say that whatever is selected should be used as the lookup value not cell d2

also there should also be an option to close the user form before 10 seconds

also if it cant find a match it should return value not found

[sintek]

See attached...

Code searches selected cell.
In future with other posts, please be more specific with your requirements, so that we can write the exact code required and not waste time.