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