Hello,

I'm new to VBA programming and am having difficulty with using the Analysis Toolpak Add-in. First some background...

I have set the reference to atpvbaen.xls and this reference appears in my project tree. I'm working with Excel 2004 on a Mac.

If, for example, I want to execute the histogram function, I use the following code and everything works fine.

Please Login or Register  to view this content.
Where I run into trouble is when I try to implement this into a UserForm. Here's the code I'm using (with some non-vital parts stripped out):

Please Login or Register  to view this content.
When I try to execute this code through the UserForm, it completes without error, but the Histogram function doesn't do anything. I can put a MsgBox statement before and after the Histogram statement and both dialog boxes display correctly.

So, what went wrong when I went from a stand-alone sub to the private Userform sub?

Thanks for any help on this... I've been searching the forums all weekend trying to find an answer.
-Chad