Hi

Im really noob how to use VBA and userforms, but here i found that you guys really make a great work with all of this.
What i need is a userform that when i introduce a number in a box it searches for that precise number in a row interval that have various numbers and if it finds it it will display an average number and a record number that are on others cells, if it doesnīt find that number it will display a message that i will define.

For example i have some numbers in cells A10:F10 and the number that i input on the userform is in C10. What i need is to show me the average number that is on C9 and the record number that is on C11, numbers wich corresponds to the number i input that is on C10. If the number that i put on search in the userform doesnt exist in the A10:F10 interval it will display a message pre-defined.

Sorry for the bad english
and
Thanks in advance