Solution Needed, please help!

[Rizitsu]

First time i've posted in this section of the forum, have mostly spen
the last week in the Misc section.

Scene set, here's the problem.

I have 2 worksheets,

worksheet 1 = numerical values
worksheet 2 = textual values

think of it like

worksheet 1 = product number and price
worksheet 2 = product description

What i would like to implement is a Userform using VBA *currentl
administrating*
on this Userform i have a textbox for a unique reference whic
identifies the different entries in worksheet 1, i want to relate thi
unique reference to the product descriptions in worksheet 2, (that i
part one of the problem), part two involves using the unique referenc
to search through the second worksheet using the Userform and retriev
information on the matching unique reference and displaying it in th
Userform, i will then try and look up a way of printing off th
matching records, and then have the option to search through a rang
and print out this range.

Thanks for the Advice, Riz.

I am currently trying to find online reference for Textboxes, userform
& validation,
unfortunately i have not found a good repository of knowledge and hav
yet to have a response to one of my threads on the misc forum.

Quick Logic:

Assign Cells from worksheet one to worksheet two,
design form, validate input on form, use validated value to searc
worksheet two,
return matching value, print out input and matching record. print ou
selection.

Thanks again

perhaps i am looking at a more complex method of doing what i want t
than i need to

 

[Bob Phillips]

You could do it all on worksheets. Why not merge the 2 tables, product
number, desc, price. You could then have a data validation cell on another
cell linked to the number list, the user could choose from that, and you
could lookup the rest. See http://www.contextures.com/xlDataVal01.html and
http://www.contextures.com/xlFunctions02.html for some help.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Rizitsu]

i should have longwinded my concerns, or my reasons for choosing such
solution,

I have un-merged the data so that worksheet one has one the numerica
data and worksheet two has the textual data, this is because th
textual data's length varied and changed the shape of the cell, much t
my disliking.

Re-Merging the cells would put me back where i started as you ca
imagine.

It seems to be a tougher solution as i cant find the most pragmati
approach to solving through my experience in VBA, i can search the msd
library for answers and never find the exact answer i am looking for, i
anyone could recommend a site of solutions, snippets or tutorials i
would be greatly appreciated.

Regards

Ri