ActiveX controls

Walking Columns

ANmar ActiveX controls / Basic Math / COLUMN / Conditional Formatting / Formulas - combined functions / IF / INT / Logical / Lookup and References / Math and Trig / Non-functions / OFFSET / ROW / Standard functions January 14, 2023 January 14, 2023

An easy way to scroll through set of data in a graphic way without graphs. A-pure-formula xlsx workbook. These were done using formulas, conditional formatting, and ActiveX control.

Dynamic selection list

ANmar ActiveX controls / COUNTA / Formulas - combined functions / INDEX / Lookup and References / Names / Standard functions February 7, 2012 December 26, 2017

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 …