ListBox in UserForm with multiple drop down entries

Hi All,

As per the attached image example, you will see 3 example entries filled in my userform - I have show an image as well as to how it looks when entered into the table.

I want to find out if it's possible to have a drop down box in the 'listbox' that allows me to select the relevant name and when I move down to the next line another drop down will appear for me to add the next etc...

The names can be fairly long and have many, so having a dropdown will avoid manually typing and user prone errors.

Thanks in advance.

Listboxes don't, and can't, have dropdowns. I'd suggest a separate control (either listbox or combobox) where you can select your reinsurer(s) and then use a button to add them to the list of applicable markets.

Add the other control (listbox or combobox) with all the available reinsurers listed in it, then your button simply needs to do something like:

Please Login or Register  to view this content.

where listbox1 is your current listbox and combobox1 is the name of the new control.

Add the other control to your form somewhere appropriate. Yes, you can list them on a sheet then populate the control in the Userform_Initialize event using something like:

Please Login or Register  to view this content.

for example.

How are you storing the data? Is it all going in one cell?

@MyForcey, please make this easier for a solution to be given by reading the big yellow banner and upload your workbook.
This is the type of query that should be solved by post #2 if all the detail is presented at the outset.
By the nature of responses it is obvious you need deeper understanding of VBA process.
Please help us to help you - upload that workbook before any more questions.

i have only made changes with userform1 code.
however your main database was a table, therefore use table referencing methods not range referencing.
if you are adopting tables use them throughout your app, i have altered the loading lists to the comboboxes and listbox to table format.
the listbox is multi-select and will save as a multi-row cell - i assume that any percentage would need to be variable - if so that would be more complex.
give it a trial - i have not included any error checking for date formats etc.,

give the attached a try, bit of a pain dealing with the multi row cell.

Hi, thank you, however it was not loading right. and an added combo box for some reason?
I've attempted a few times with naming etc but no luck... I've changed a few things. do you mind having a look at this copy (attached)?
should be able to use the "UserForm1" code and just have it so that the fields in the "UserForm3" will auto populate depending on the row I've selected?

Please shout if you require more information from me.

The "reinsurers" field (I.e the multi-row) - that does not need populating only the other fields (I just need the option as in UserForm1 to select the reinsurers).

Much appreciated.

I will bow out at this stage - the app is becoming a patch work of methodology.
Firstly I do not attempt mixing on sheet formula/formatting/conditional formatting/data validation with VBA UserForms.
The sheet is used as a data store(pseudo database) all other actions to take place within the code - remove all the ActiveX buttons from your sheet.
Data handle with a single UserForm - eliminate repetitious code - do not extend data tables below the last row of data.
The extra combobox enables you to search for your file without bouncing back and forth between forms.

re-read post#12, you are using tables, therefore read-up on their useage, do not develop a 'hodge-podge' mix of tables and range referencing.
you can not simply paste a block of code from my app into your app and expect it to work, you need common foundations.
simple things need progressive alteration, simple example, the tables that load your comboboxes have a cluster of empty rows at the bottom of the table.
now look at your listbox, this has the effect of loading your listbox with numerous rows of 'nothingness' , now delete the empty rows from the tables and 'nothingness' dissappears.
I would be doing you a dis-service if I solved individual items without considering the overall app and its future stability and suitability.

you do not mix 'tables' and 'ranges' use one or the other - your main database is a 'table' - learn the correct referencing syntax.
the attached file is your app simplified and condensed to one form - the code is annotated for you to follow and the pdf has the code layout so that you can follow the loops and code flow - you should not be confused if you read it through several tmes.

Hi, thank you.
I had a brief look now, I highly appreciate the effort you put in and trying to inform me of how things should be done.

I will follow the pdf accordingly.

Thank you for the effort and time.