vba - dependable combo box - runtime error '1004'

Hi,

I am very very new to VBA and need help with this VBA code.

I am creating a search data base. This database will have 2 search functions. One search funtion has 3 combo boxes which are dependable on each other (which is working). Now I want to create the second search option which will 2 comboboxes and again need to be dependable so that staff will be able to either search though comboboxes 1-3 OR 4-5. I get error in this line when I try to run the code (For rowNum = .Range(nameRange).Row + 1 To .Cells(Rows.Count, .Range(nameRange).Column).End(xlUp).Row)

full code

Please Login or Register  to view this content.

Please help! Thank you

Hello plavooka23 ,

Welcome to the Forum!

If you can post a copy of your workbook for review, it will help expedite a workable solution. If you have any sensitive or confidential information in the workbook then please redact it before you post the workbook.

To Attach a File:

1. Scroll down to the window below your post Additional Options
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 Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
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 button and wait until the file has uploaded.
10. Close the window and then click Submit.

Dude can you add some code tags

and What error type?

It very hard with out the workbook

Please Login or Register  to view this content.