Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solution Needed, please help!
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 -- Rizits ----------------------------------------------------------------------- Rizitsu's Profile: http://www.excelforum.com/member.php...fo&userid=1584 View this thread: http://www.excelforum.com/showthread.php?threadid=32055 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solution Needed, please help!
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" wrote in message ... First time i've posted in this section of the forum, have mostly spent 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 *currently administrating* on this Userform i have a textbox for a unique reference which identifies the different entries in worksheet 1, i want to relate this unique reference to the product descriptions in worksheet 2, (that is part one of the problem), part two involves using the unique reference to search through the second worksheet using the Userform and retrieve information on the matching unique reference and displaying it in the Userform, i will then try and look up a way of printing off the matching records, and then have the option to search through a range and print out this range. Thanks for the Advice, Riz. I am currently trying to find online reference for Textboxes, userforms & validation, unfortunately i have not found a good repository of knowledge and have 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 search worksheet two, return matching value, print out input and matching record. print out selection. Thanks again perhaps i am looking at a more complex method of doing what i want to than i need to. -- Rizitsu ------------------------------------------------------------------------ Rizitsu's Profile: http://www.excelforum.com/member.php...o&userid=15840 View this thread: http://www.excelforum.com/showthread...hreadid=320551 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solution Needed, please help!
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 -- Rizits ----------------------------------------------------------------------- Rizitsu's Profile: http://www.excelforum.com/member.php...fo&userid=1584 View this thread: http://www.excelforum.com/showthread.php?threadid=32055 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing with multiple conditions - Formula solution needed | Excel Worksheet Functions | |||
Possible Array Solution Needed? | Excel Discussion (Misc queries) | |||
Need a pop up solution! | Excel Discussion (Misc queries) | |||
My solution | Excel Discussion (Misc queries) | |||
urgent solution needed to 'custom view' re-calculation problem! | Excel Discussion (Misc queries) |