Transferring Data from Userform Listbox to Drop-down list in Worksheet

Hey guys!

So my goal in this project is to create a userform that retrieves from the worksheet and also allows users to input data themselves from the userform and into an one column listbox on the userform. When the user is done entering in the data, the data is sent into the cell of their choosing (they enter in the row # themselves and it will always be column H), and creates a drop down list of the data they entered.

So far, I have created the userform and with retrieve, erase a line from the listbox, and a "complete& close" buttons. I also have the listbox and the textboxes made. The "complete & close" button is where i look to transfer the data from the listbox from the userform into the drop down list.

I'm not actually sure if this is possible, so I have been working my way around this problem. What I have now is that the listbox data transfers to a useless column on the worksheet in hopes to use that as the range for the drop-down lists. Unfortunately, I just realized that this would probably not work because the drop-down lists would change with the data in this column. Is there a way to make it so that once these drop-down lists are made, they no longer depend on the range and do not alter until the userform calls upon that particular cell again?

I know this is a complicated problem, but please ask for you guys to help! I'm pretty much a novice in VBA and I don't completely understand the limitations of Excel VBA. Help would be much appreciated for this problem that has been giving me headaches for days.

Thanks!

Hi f5awp and welcome to the forum. Firstly, you need to give us time here at the forum as solutions to problems aren't always quickly provided. You waited just over an hour before you asked for help again on the same issue, and that's just too quick. Secondly, it would probably benefit you more to upload a workbook with non-sensitive data with a before and after scenario of your requirements. Doing so will remove most of the guess work by those that donate their time to help others.

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.

You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file.

To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Regards: