Combo box not showing full list

new new.xlsm


Hello all in the attached I have six combo boxes that feeld of a list on the calculations page. for whatever reason it will not display the whole list, and even when i get it to do that the connected passwords only work for the first several guys on the list.

Secondly the start stop buttons keep resizing. I have stretched them to match the cells they are in but every time I click them they resize.

Please help.

P.S.

I belive i have unlocked everything but if i have not

All sheet passwords = Traveler
VBA password = Touchdown_97

Thanks, but where do i go to fix the issues you describe? I have had alot of help building it so not sure where to go to fix.

Thanks, but where do i go to fix these issues? and what is a dynamic range? I have had alot of help building this so no i am lost.

Go to Formulas, Name Manager, and click on tblEmployees. Update the range from CALCULATIONS!$A$2:$A$92 to be this formula:

Formula:

=OFFSET(CALCULATIONS!$A$3,0,0,COUNTA(CALCULATIONS!$A:$A),1)

This formula will always capture all the employees in the list no matter how many are added or removed.

Go to Developer, click on Design. Right click on each of your comboboxes and set the ListFillRange property to be tblEmployees.

Now you have a dynamic range to list employees and every place that needs to refer to that list is using the same range.

These seemed to be locked somehow

You have to unprotect the sheet first.