ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drop down starts on wrong row (https://www.excelbanter.com/excel-discussion-misc-queries/192070-drop-down-starts-wrong-row.html)

ray72

Drop down starts on wrong row
 
I have defined an input range $F$2:$F:$51, but the combo box starts on row
11. Any ideas? Thanks.

ray72

Drop down starts on wrong row
 
Just realized that the Combo Box range is affected by the window room. In
other words, if I zoom down to 75%, I get more of the range. Is there any
way around this problem or must I use a List Box?

"ray72" wrote:

I have defined an input range $F$2:$F:$51, but the combo box starts on row
11. Any ideas? Thanks.



All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com