ActiveX Combobox displays wrong number of lines
I have a Combobox with the listrow set to 5 yet it displays three listrows.
Not only that but the range comprises five cells yet the drop down does not have the up/down arrow for scrolling so the bottom 2 can't be chosen.
If I'm pretty sure ActiveX controls are buggy if there is someone who can point me at something obvious then I'll be eternally grateful.
PS this Combobox used to refer to as the range that had a three cells and I also had the listrow property set to three, somehow the changes just don't seem to carry through although the data presented in the drop down is from the new range even though the drop down is the wrong length and also cannot access the bottom two members of the five member data set.
To cut a long story short.
The range the box refers to refers to another range
the information from that incorrectly referred range makes it into the ActiveX control.
The control seems to ignore its listrow property and doesn't make even scrolling an option to access further members of the data range.
EE5.jpg
EE6.jpg
EE7.jpg
EE8.jpg
Not only that but the range comprises five cells yet the drop down does not have the up/down arrow for scrolling so the bottom 2 can't be chosen.
If I'm pretty sure ActiveX controls are buggy if there is someone who can point me at something obvious then I'll be eternally grateful.
PS this Combobox used to refer to as the range that had a three cells and I also had the listrow property set to three, somehow the changes just don't seem to carry through although the data presented in the drop down is from the new range even though the drop down is the wrong length and also cannot access the bottom two members of the five member data set.
To cut a long story short.
The range the box refers to refers to another range
the information from that incorrectly referred range makes it into the ActiveX control.
The control seems to ignore its listrow property and doesn't make even scrolling an option to access further members of the data range.
EE5.jpg
EE6.jpg
EE7.jpg
EE8.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.