LinkBack URL
About LinkBacks
Revolversus2 
Thank you HaHoBe. Here's the form and code as per request. To bring up the user form, just click on any empty cell on the Sheet1.
Thank you HaHoBe. Here's the form and code as per request. To bring up the user form, just click on any empty cell on the Sheet1.
Last edited by Revolversus2; 04-17-2014 at 11:40 PM.
Hi, Revolversus2,
Which form are we talking about (I think UserForm1), what controls for the choice (I´d expect at least ComboBox1 and TextBox2 but I´m not sure about the third one as well as the CommandButton) as now the whole form is filled.There are three text boxes to key in the filter criteria and a button which will filter the data
Maybe have a look at http://www.excel-it.com/excel_databaseform.html: you make a choice, the result is displayed in a listbox and by making a choice you can display the information in textboxes.
Ciao,
Holger
Last edited by HaHoBe; 04-17-2014 at 11:52 PM.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Sorry for being vague. The form is indeed UserForm1.
User needs to enter two keywords into two textboxes, criterion1 and criterion2 (the two text boxes at the bottom) and by clicking on the Search button, the form will search the spread sheet for cells containing the keywords and display the whole row on the text boxes and combo boxes inside the group box labelled "Organizational Detail".
I was planning to include another text box, criterion3 so that the user can filter results using up to three key words.
Hi HaHoBe,
Thank you very much for the link. It helps to solve my problem ^^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks