Hello group,

how can I call statistic funtions from vba (Histogramm)?

On Dec 6, 9:59 am, iwl wrote:
Hello group,

how can I call statistic funtions from vba (Histogramm)?

Use WorkSheetFunctio. (dot) and select the available function.

Although the Histogram is not a standard function. So you'll have to
track creation with the Macro recorder and then modify the code for it
to do what you want in VBA.

SteveM

On 6 Dez., 16:16, SteveM wrote:
On Dec 6, 9:59 am, iwl wrote:

Hello group,

how can I call statistic funtions from vba (Histogramm)?

Use WorkSheetFunctio. (dot) and select the available function.

Although the Histogram is not a standard function. So you'll have to
track creation with the Macro recorder and then modify the code for it
to do what you want in VBA.

Hi,

found it out up to that point up to now.
But when I try to call this macro or use it from vba I allways get
errors, don't found the according xla file, don't found the macro
I have clicked all references in excel and vba to the analysis file
nothing helps, many peaople seems to have problems with calling
the analysis functions from macros / vba.

On 6 Dez., 17:34, iwl wrote:
On 6 Dez., 16:16, SteveM wrote: On Dec 6, 9:59 am, iwl wrote:

Hello group,

how can I call statistic funtions from vba (Histogramm)?

Use WorkSheetFunctio. (dot) and select the available function.

Although the Histogram is not a standard function. So you'll have to
track creation with the Macro recorder and then modify the code for it
to do what you want in VBA.

Hi,

found it out up to that point up to now.
But when I try to call this macro or use it from vba I allways get
errors, don't found the according xla file, don't found the macro
I have clicked all references in excel and vba to the analysis file
nothing helps, many peaople seems to have problems with calling
the analysis functions from macros / vba.

There Seems to be a problem with the German
atpvbaen/de file it does not work for some reason.
I had to setup a new link in the vba references pointing to the
english
atpvbaen.xla file and now can use the english version of the command
(histogram)