Seeking Input through userform and searching the spreadsheet for corresponding entry

[himanshu83]

Hi,

I have been an avid excel user but entering the world of VBA just now out of necessity. I am trying to design a GUI where user selects a string from the "combobox" and enters some value in the "text box" below it.

Now I want to write a code to search for the entered text and entries related to that and publish the result in a new spreadsheet.


which commands/technique should I use for this task?

Please let me know if you could help. I can send a sample excel sheet if required.

Thanks,
Himanshu

[BigBas]

The information you have provided is a bit vague. What does the combobox do? Likely, you will need to use the FIND method. Some info can be found at this link http://www.ozgrid.com/VBA/find-method.htm

If you need more specific help, perhaps post a sample workbook with additional details.

[himanshu83]

Thanks for your input.. but I don't know how to attach a sample sheet here.
However, I'll try to explain what I am trying to accomplish.

I have a listbox (lbProducts) with a list of products and a set of 10 textboxes (txtProduct1 to txtProduct10) There is a CommandButton (btnSelect) in between listbox and textboxes.

So, when the user clicks on an object in listbox and clicks on "btnSelect", the select object is copied to next available textbox, starting from txtProduct1.

In short I want to allow user to select upto 10 objects from listbox and copy them to txtProduct 1 to txtProduct 10.