Combo List

Hey guys,

I want to make a UserForm and i'm stuck at a simple operation. I need a list in my form, simple "Name/Number" list (only two options) but i don't want it to refer to any cell in the worksheet.
I want to input a text in a textbox and with the selection in the list above i want to have multiple choices at how to approach the text (if i input a name i want it to be different than if i input a number). All the info i came up on the web refers to lists made upon a range of cells.
How can i make a list without involving ranges of cells?

Good morning kroz

Originally Posted by kroz

All the info i came up on the web refers to lists made upon a range of cells.
How can i make a list without involving ranges of cells?

I must admit I'm not entirely sure what you mean, but this is how you populate a listbox (in this instance called ListBox1) without involving a range of cells. You will need an event to hang this from - if you're having the items in the listbox change when a text box is entered, then the UserForm_Initialize event may not be the right one for you :

Please Login or Register  to view this content.

HTH

DominicB

I changed the strategy a bit - i got my search engine inside the cells in the sheet and all i need to do is put the name in column A of each row.

Please Login or Register  to view this content.

I solved the while problem - I forgot to put the condition to get out of the loop. The problem now is that it doesn't take all the data in the name. If i input "Owner of the account * John McDee Erby (max access account)" it will take "John McDee Erby (ma".
In other recordings it doesn't take the whole name..
I must be missing something..