What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?

Google is full of information on this. As Hans Passant said, Form controls are built in to Excel whereas ActiveX controls are loaded separately.

Generally you’ll use Forms controls, they’re simpler. ActiveX controls allow for more flexible design and should be used when the job just can’t be done with a basic Forms control.

Many user’s computers by default won’t trust ActiveX, and it will be disabled; this sometimes needs to be manually added to the trust center. ActiveX is a microsoft-based technology and, as far as I’m aware, is not supported on the Mac. This is something you’ll have to also consider, should you (or anyone you provide a workbook to) decide to use it on a Mac.

Related Posts:

  1. What exactly is the function of Application.CutCopyMode property in Excel
  2. What does <> mean?
  3. How to find a value in an excel column by vba code Cells.Find
  4. What is the function of FormulaR1C1?
  5. VBA Excel – Insert row below with same format including borders and frames
  6. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  7. How to install Date Picker form control in Excel 2016
  8. How to install Date Picker form control in Excel 2016
  9. How to fill color in a cell in VBA?
  10. Refreshing all the pivot tables in my excel workbook with a macro
  11. Average in VBA in Excel
  12. VBA Excel “Compile error: Object Required”
  13. Choosing paper size (NOT DEFAULT sizes) in excel vba
  14. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  15. Paste Special error 1004 PasteSpecial method of Range class failed
  16. VBA: Getting run-time 1004: Method ‘Range’ of object ‘_Worksheet’ failed when using cells
  17. Cannot run the macro… the macro may not be available in this workbook
  18. Swap x and y axis without manually swapping values
  19. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  20. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  21. Object Required Error in excel VBA
  22. Insert picture into Excel cell
  23. Check if a string contains another string
  24. VBScript to open a dialog to select a filepath
  25. Does VBA have Dictionary Structure?
  26. What are .NumberFormat Options In Excel VBA?
  27. Better way to find last used row
  28. VBA, if a string contains a certain letter
  29. Excel VBA Macro: User Defined Type Not Defined
  30. “Sub or Function not defined” when trying to run a VBA script in Outlook
  31. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  32. Select method of Range class failed via VBA
  33. Does VBA contain a comment block syntax?
  34. Why does “Paste Method of Worksheet class failed” occasionally occur?
  35. Deleting a file in VBA
  36. How to return a result from a VBA function
  37. How to clear memory to prevent “out of memory error” in excel vba?
  38. Use VBA to Clear Immediate Window?
  39. VBA: Else without If Error
  40. Recommended IDE for VBA
  41. ByRef argument type mismatch in Excel VBA
  42. How to comment and uncomment blocks of code in the Office VBA Editor
  43. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  44. VBA: Convert Text to Number
  45. VBA Error: “Compile error: Expected End Sub”
  46. Scraping data from website using vba
  47. Pass arguments to Constructor in VBA
  48. Error: “Could Not Find Installable ISAM”
  49. Loop without Do error
  50. Row count where data exists
  51. Test or check if sheet exists
  52. How to detect if user select cancel InputBox VBA Excel
  53. macro run-time error ‘9’: subscript out of range
  54. Why does my VBA code throw an “Invalid outside procedure” error?
  55. VBA: Run time error ’91’?
  56. Compare Dates in VBA
  57. ‘Cannot find DAO350.dll’ file error VB6
  58. Excel Solver Password: what is it and where can it be acquired/bought?
  59. Using Excel VBA to run SQL query
  60. Compile error: Next without For || VBA
  61. Is there a way to crack the password on an Excel VBA Project?
  62. MS Excel Scatterplot converts Months to Numbers
  63. Substring in excel
  64. IndexError: too many indices for array
  65. Excel to Google Sheets – Error: Formula parse error
  66. IndexError: too many indices for array
  67. Looking for a clear description of Excel’s .xlsx XML format
  68. Invalid column count in CSV input on line 1 Error
  69. ERROR Error: No value accessor for form control with unspecified name attribute on switch
  70. excel IF formula Error, “You’ve entered too many arguments”
  71. No value accessor for form control
  72. Export html table data to Excel using JavaScript / JQuery is not working properly in chrome browser
  73. What is a correct MIME type for .docx, .pptx, etc.?
  74. Is there Infinity in Spreadsheets?
  75. How to fix file format and extension don’t match?
  76. How to loop in excel without VBA or macros?
  77. How can I open an Excel file in Python?
  78. ValueError: cannot index with vector containing NA / NaN values
  79. How can I import an Excel file into SQL Server?
  80. What is correct content-type for excel files?
  81. How do I get countifs to select all non-blank cells in Excel?
  82. lists and arrays in VBA
  83. How to run a SQL query on an Excel table?
  84. Excel – SUMIFS for multiple columns
  85. Workaround for “Formula omits adjacent cells”
  86. IE11 prevents ActiveX from running
  87. ImportError: No module named win32com.client
  88. Excel Filters – show only relevant values in the filter
  89. Select all the cells below current cell in excel
  90. Syntax error on token(s), misplaced construct(s)
  91. VBA for Cross Products in Excel
  92. Error -1072896636 “DTD Prohibited” when opening xml file in Excel, what do I do?
  93. Using SUBSTITUTE with wildcard characters
  94. Change default ‘delimiters’ in excel
  95. Adding a newline character within a cell (CSV)
  96. (Excel) Conditional Formatting based on Adjacent Cell Value
  97. Is there a coalesce-like function in Excel?
  98. Converting Excel Column with To SSRS (inch or pt)
  99. How to label scatterplot points by name?
  100. How to Clear Office Clipboard with VBA

Leave a Comment

tech