Excel 2013: Userform combobox dropdown List with multiple rows

[jedwardo]

Hello All,

Working on my estimate spreadsheet. The goal is to be able to walk into a customers house with my tablet and be able to pick the items off of a userform. For ease of use I've increased the font size from default and am wanting to eliminate the need to use scroll bars as much as possible so I'm not fumbling around on the tablet trying to use the spreadsheet like an oaf in front of the customers. Is it possible to make the combobox dropdown lists display the options in multiple rows so the longer lists don't need to be scrolled? Here's a pic of example:

[/IMG]

Combobox name is "ComboBoxOperation". Userform name is "UserFormMain" Not sure what all info I'd need to supply for this one so just let me know if you need screenshots or anything else.

Thanks,
Jordan

 

[MickG]

It is possible to have a multiple column "Combobox" but you would need to increase the width to show all columns and have a piece of code to change the "Combobox.BoundColumn" on value selection, another thing is I'm not sure if its possible to show the chosen column value in the Combobox, it seems to default to column 1 value, although you can show the selected column value in a textbox.
You can actually cover the Viewing area of the combobox with the Textbox.
So its a bit of a compromise, but quite possible, are you still interested.???

 

[jedwardo]

That would be perfect. The userform gets reset after each room is transfered to the worksheet and is mainly about practicality. So I just need to double the width of the combobox, create a new textbox placed on top (changing code to read the text from textbox instead of text from combobox) and then change the boundcolumn value?

 

[MickG]

Have a look at this example and the Userform code Remarks
You should be able to modify its principle for your use.
It may be possible to remove the Text box to get the actual selected column Value, but I have not found it yet !!!!
https://app.box.com/s/pjxq4ub116hyho9azgq4

 

[jedwardo]

Thanks Mick!! That did exactly what I needed, that example spreadsheet was awesome. I found another value in the combobox properties (ListWidth) that lets you set the total width of the dropdown list without having to resize the whole combobox too.

 

[MickG]

Glad its working for you.
Good shout on the "Listwidth" I had'nt used that before.!!!
Regrds Mick