N
Nick
I have an excel spreadsheet with a few activeX combo boxes to allow the user
to select some filtering options on some data. Unfortunately, each time the
user clicks on the combo box, it either gets incrementally bigger or smaller.
For example, here is my scenario:
Two combo boxes, "enrollSite" and "enrollDept"
They are the same size
When user clicks on enrollSite, the font and size of enrollSite goes up by
one (looks correct in properties)
When user then clicks on enrollDept, the font and size of enrollDept goes
down by one (looks correct in properties)
User can continue to click between these boxes to make them huge or tiny
This happens regardless of protection
The weird thing is that sometimes one will get bigger and the other smaller,
and sometimes they will both get bigger. Any ideas as to why this happens
and how to fix it? Because the properties don't change, I do not believe
creating a macro to watch the values and reset them if necessary will work.
I appreciate any help that anyone can provide as I have googled this issue
to death and can only find instructions for how to change the font or size of
a combo box (which I certainly know how to do ;o).
to select some filtering options on some data. Unfortunately, each time the
user clicks on the combo box, it either gets incrementally bigger or smaller.
For example, here is my scenario:
Two combo boxes, "enrollSite" and "enrollDept"
They are the same size
When user clicks on enrollSite, the font and size of enrollSite goes up by
one (looks correct in properties)
When user then clicks on enrollDept, the font and size of enrollDept goes
down by one (looks correct in properties)
User can continue to click between these boxes to make them huge or tiny
This happens regardless of protection
The weird thing is that sometimes one will get bigger and the other smaller,
and sometimes they will both get bigger. Any ideas as to why this happens
and how to fix it? Because the properties don't change, I do not believe
creating a macro to watch the values and reset them if necessary will work.
I appreciate any help that anyone can provide as I have googled this issue
to death and can only find instructions for how to change the font or size of
a combo box (which I certainly know how to do ;o).