Hi All,
This is probably very obvious, but I can't figure it out.
I have a combobox pull down list that was working great until I added another item to the list. The list source is a formula, and that is working perfectly. But the combobox drop down feature did not add an additional row to the list. I'm not very fluent with the combobox properties, so I suspect the answer is there somewhere. I do know enough to have increased my ListRows. I only went from 5 to 6 items in my list and the ListRows was 8 (default). I increased ListRows to 10, just in case, but that did not change anything I can see from the dropdown list. The 8 row default did not mean I had 5 items and 3 blanks, btw. I only had 5 rows. I still have 5 rows, but I have 6 items in the list that should be showing.
Any suggestions?
Thank you so much for any help,
KBSpec
This is probably very obvious, but I can't figure it out.
I have a combobox pull down list that was working great until I added another item to the list. The list source is a formula, and that is working perfectly. But the combobox drop down feature did not add an additional row to the list. I'm not very fluent with the combobox properties, so I suspect the answer is there somewhere. I do know enough to have increased my ListRows. I only went from 5 to 6 items in my list and the ListRows was 8 (default). I increased ListRows to 10, just in case, but that did not change anything I can see from the dropdown list. The 8 row default did not mean I had 5 items and 3 blanks, btw. I only had 5 rows. I still have 5 rows, but I have 6 items in the list that should be showing.
Any suggestions?
Thank you so much for any help,
KBSpec
Last edited:
