Triggering Different Dropdowns Based on Original Dropdown

Hi all,

Ok, so here is my problem. I have several different categories of data, with each list named after the full category title. The data is stored on another worksheet. On the worksheet that will be interacted with, there is a dropdown menu that allows you to choose which category of data you want. I am trying to get a macro that produces a dropdown menu the next column over of all the items in that category. Here is the code that I have so far.

Please Login or Register  to view this content.

'cat' is the cell that contains the name of the cell range that has all the data that I want in the dropdown menu. I know the problem lies in the red highlighted portion of the code. I can't get the Formula1 to accept the value of 'cat' as a named cell range. Any help would be greatly appreciated.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here