why are there difference between a listbox created with the vba toolbar (on a spreadsheet) and one created using worksheets().dropdowns.add (also on a spreadsheet)?
the toolbar version allows much more control than the 'macro' version, which only allows access to a linkedcell, item list, and a hook for an "onchange" macro. No formatting or other handling.
Is it possible to create the toolbar version from a macro? I have tried creating one manually and then accessing it from a macro, but it doesn't seem to be part of the worksheet collections.
the toolbar version allows much more control than the 'macro' version, which only allows access to a linkedcell, item list, and a hook for an "onchange" macro. No formatting or other handling.
Is it possible to create the toolbar version from a macro? I have tried creating one manually and then accessing it from a macro, but it doesn't seem to be part of the worksheet collections.