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.
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):
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
Bookmarks