Archives: ActiveX controls



Index, CountA, Names and Listbox to have active form reading from table

Using Index and CountA Formulas, Names and Forms > ListBox to have a list with connected formulas Can also be used as form to read from a large table in another sheet   After creating two names, one is “Months” having: =OFFSET(Sheet1!$B$5,0,0,COUNTA(Sheet1!$B:$B)-2,1) And the other one is “Month_All” having: =OFFSET(Sheet1!$B$5,0,0,COUNTA(Sheet1!$B:$B)-2,3) Draw a listbox using “Developer • Read More »