$$Excel-Macros$$ Re: multiple dropdown lists height problem

I fixed it, without finding the root cause: Private Sub Workbook_Open() For Each ws In Worksheets For Each dd In Worksheets(ws.Name).DropDowns dd.Height = 15 Next Next end sub It is not a good way, but it works. If anybody has an idea what the root cause ist, please post it! --

$$Excel-Macros$$ multiple dropdown lists height problem

Hi, I have the following problem, when I create some dropdown boxes via VBA then all 99 ones have the some height and length in the excel sheet. But when I save the file and open it again, then some of the dropdown boxes are smaller or bigger then before. Has anybody a good idea? Thank you Code: