.dropdown

  • Thread starter Thread starter sunilpatel
  • Start date Start date
S

sunilpatel

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top