Form textbox with multiple criteria search

**Vlad999** · 09-23-2009, 01:48 AM

Hi,

I am trying to create a form where the user selects from 3 combo boxes clicks a button then the text boxes in the form populate.
However I am unable to work out how to do a search for the 3 criteria then return the cell to the text box. (I am searching in columns A to C).

Any help would be appreciated.

BTW I suck at VBA still learning so treat me like a noob

**JBeaucaire** · 09-23-2009, 02:51 AM

Let's see your workbook and the form you've created. In your sample sheet perhaps some clear examples of what you might select in your comboboxes and what the possible return should be when your search button is clicked.

**Vlad999** · 09-23-2009, 03:09 AM

Its still very much a work in progress so I will explain as best I can.

I am planning on having 3 tabs with data titled Actual, Budgeted and Modified these worksheets relate to combobox4 so by selecting any of the three options the used defines what worksheet to look start the search in.

The next combobox2 relates to a sales channel and the user can select from Total, Pharmacy, Grocery, Export and Other this links back to column B.

The third combobox3 relates to a brands 1-9 found in column C.

I will also need to define within the search the measure being used (this is not selectable by the user) to complete the search.

So for example for textbox1 (this text box relates to the measure Gross Sales on the user form) to retrieve a value the user would select Actual, Pharmacy, and Brand 1. The returned value would be 141,798 (cell D88).

Hope this helps