Thread: Userform
View Single Post
  #1 (permalink)  
Old August 25th, 2011, 10:50 AM
pescioletto pescioletto is offline
Registered User
Points: 20, Level: 1
Points: 20, Level: 1 Points: 20, Level: 1 Points: 20, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2011
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default Userform

Hi,

I have following data in cells A2:D12 in Sheet2

category fruit number colour
a apples 10 red
b pears 12 green
c apples 5 green
d bananas 4 yellow
e apples 9 red
f bananas 7 yellow
g apples 8 red
h cherries 2 red
i bananas 3 yellow
j cherries 2 red

I would like to create a Useform in Sheet2 so that when I put fruit name in textbox eg. apples then I click command button I get in Sheet1 (starting from Cell A1) the list of numbers for that specific fruit. So if I put apples I would get 10, 5, 9, 8.

How do I do that?

Thanks,
P.
Reply With Quote