vba code to show rowsource and then filter to show certain returns

[zak.horrocks]

I am trying to return any results in a combobox that contain the word David in a named cell range (ID), my code is:

Select Case Me.ComboBox1.Value
Case "David Tournay": Me.ComboBox2.RowSource = "ID"
If RowSource = "David Tournay" Then show "David Tournay"
End Select
End Sub

I'm clearly missing some code towards the end of the third line but I don't know what. Please help!

Thanks

Z

[jaslake]

Hi zak

Please use Code Tags around any Code you post.

You have several Threads that seem to revolve around this same issue.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and, if appropriate, an "After" worksheet that demonstrates what you wish the output to be.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.