How i can choose some number from the excel [Closed]

Question

How i can choose some number from the excel [Closed]

Report

eddy - May 3, 2010 at 01:03 AM
Trowa - May 3, 2010 at 08:19 AM

dear all,
I am working on excel,
situation : I have write different item names in one coloumn say coloumn a, and all the disciption of these items are in the same row and in different coloums, say

Item Price Colour Place
a10
a11
..
..
..
etc.

Task:
I made a form in which I want when user enter item number it will show Item no. including
item discription in different boxes.

I know how to made form but dont know how to write code:
1. How machine will select the item from excel sheet when user will enter it on the user form?
2. How it will collect information from the excel sheet and display on the another form?

could any body help me please, will be very thank ful.
thanks
Eddy

How i can choose some number from the excel
How to choose how many bestfriends on snapchat - How-To - Instant Messaging
We've noticed some unusual account activity. for your safety, choose a method below to verify that it's really you signing in to ✓ - Forum - Yahoo Mail
Gameranger please choose the game application - Forum - Call Of Duty
Choose an operating system to start windows 7 - How-To - Windows 7
We`ve noticed some unsual account activity ✓ - Forum - Yahoo Mail

1 reply

Ask a question

Trowa · Answer 1 · 2010-05-03T08:19:36-0400

Answer 1 / 1

Trowa
May 3, 2010 at 08:19 AM

Hi Eddy,

Why would you want to use a UserForm for this?

Create an empty sheet, use a cell to input "item no." and use the Vlookup function to collect the corresponding data.

Unfortunatly my VB knowledge isn't big enough to write a code for you.

Best regards,
Trowa

How i can choose some number from the excel [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!