userform combo box buggy

[orsm6]

Hi all - have recently built a userform containing combo boxes that i have turned into a drop down list.

the way it works is that on my sheet named 'lists' i have a named range. Then in the properties of the combo box i have typed the name of the named range in field RowSource.

the problem is that sometimes it will show me all of the contents of the named range and sometimes it wont.
I have extended the ListRow field to 30 and it still won't consistently work.

is there something I am missing or a better way to get my drop down list on the userform?

TIA

 

[Akuini]

Please share the link here not via PM, so everyone can access it.

 

[diddi]

sounds like you initialize both comboboxes in the userform_initialize sub. you need to dump all of the userform_initialize code into a new sub, then you can call the new sub from userform_initialize and from combobox1_change event, or as suggested, post the code so we can see what you are trying to do and mod what you have

 

[orsm6]

sounds like you initialize both comboboxes in the userform_initialize sub. you need to dump all of the userform_initialize code into a new sub, then you can call the new sub from userform_initialize and from combobox1_change event, or as suggested, post the code so we can see what you are trying to do and mod what you have

I'll put up a link soon. The code I have works, but it needs to be a dynamic list. Currently the list doesn't change.

 

[orsm6]

Hi all i managed to get a work around on this. I am a bit fussy, so it isn't exactly what i wanted but, this code works enough.

Sub UserForm_Initialize()

'action drop down lists
ComboBox15.RowSource = "Lists!R1:R20"

end sub

i tried adding this line in ComboBox15.RowSource = "Lists!R1:R" & Range("R" & Rows.Count).End(xlUp).Row .... but it would only show the first item in the list range, not all of them