Is it possible to create a dropdown list with VBA?

Hello & Welcome to the Forum,

Sounds possible, but it would help to see a sample worksheet with: layout, type of data, what you want in the drop down, etc?

Hmm, I may be forum-ly challanged, because I don't see a link to attach the workbook.

Pretty much what I am trying to do is, when this button creates a new worksheet, I would like to add a dropdown menu in one of the cells that uses a named array as its data. The named array is a dynamic list based off of data in another worksheet.

So far I've found the code:

Please Login or Register  to view this content.

This creates a drop down menu in cell 1,1, but I cannot seem to get that drop down to reference the named array "bleh" as its data.

And yes, these worksheets are in the same workbook

Any input?

Hello construct ,

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.

Try this update. When you create a new sheet a drop down for subcategories will be added to column I.

Hopefully you can follow the code and place any more you may need, but it not, post back and we will see what we can do.

I played with the code a bit and got everything working! I really appreciated it, y'all are life savers

The code

Please Login or Register  to view this content.