.dropdown
I figured out why this was occuring. It was because i had a freeze pane
under the combo box, and the dropdown list would have crossed it. to
overcome this, i now scroll to row 1 and then combo dropdown
behaves as expected and ignors freeze pane.
Thanks
"sunilpatel" wrote in message
...
when i use this line
ActiveSheet.ComboID.DropDown
the dropdown menu is above the combobox. How can i make the list drop
downwards rather tha upwards.
This effect does not occur if i manually click on combobox to view list.
Thanks
|