getting a run time error 1004, trying to create a combobox

[dmcgov]

here is my code to initialize the form:

Please Login or Register  to view this content.

what am i doing wrong?

[CK76]

Is scope of named range set to workbook or worksheet?

If former, try just using Rane("Names") instead of ws.Range("Names")

[dmcgov]

thanks CK, but i changed this one line and it's working now.

Please Login or Register  to view this content.

i added the ThisWorkbook to the set statement.

[CK76]

Glad you got it solved. I actually ran some tests and scope had no impact when it's set to workbook.
I guess, you had another workbook active when the code ran.

[dmcgov]

one quick question, im trying to create a combobox that lists two ranges, the first one is named Hours and the second is offset to that. so why isn't this working?

Please Login or Register  to view this content.

[CK76]

What's the end result you are trying to achieve?

Should both be loaded to same combobox and selected as one?

If so do something like.

Please Login or Register  to view this content.

Or are you trying to do something different?

[dmcgov]

ok so that shows the combobox with both columns of text, but when i pick something off the list, then it only returns the first column in the combobox. see snapshot. how do i fix that?

combobox1.png

[CK76]

That's expected behavior of Combobox. Combobox can only display value of first visible column.

I've experimented with it before. But there really isn't direct way to show both columns.

One method is to use caption or text box above combo box to show both.

Another is to have 3rd column added to range concatenating 1 & 2.
Then setting column width of 1st and 2nd to 0. Hence, showing 3rd column only.

Please Login or Register  to view this content.

Or use _Change event to change ColumnWidth.

Please Login or Register  to view this content.

Or just use listbox instead of Combobox.