Set treeView_PopupMenu suddenly failed (vba); cured by re starting windows7. Nasty shock - seek advice re explanation/prevention.

Kelvin4
Kelvin4 used Ask the Experts™
on
Hello,

In Excel 2010, I have recently built my first TreeView popup menu which enables procedures to be called when right clicking a tv node from a UserForm TreeView control. All was going fine ...

... Suddenly, earlier file versions (that worked well on previous days)  FAILED at the following step:

Set treeView_PopupMenu = Application.CommandBars.Add(name:="UserForm1Popup", _
                                                 Position:=msoBarPopup, _
                                                 Temporary:=True)

Blood running cold - I re-started Windows 7 - and the problem disappeared.  
I have no clues re the failure, but does the evidence suggest the cause was outside the excel piece?

Has anyone had this experience? My piece is intended for distribution. I hope to understand what happened, to head-off the problem if possible, or arrange for a less disconcerting crash.

Can I do better than put in an error trap that directs the user to restart the computer?

I have continual AVG anti-viral cover. I carry our occasional checks with SuperAntiSpyware  (http://www.superantispyware.com/downloadfile.html?productid=SUPERANTISPYWAREFREE), but it was not on when this occurred.

I had to restart my PC yesterday because my old Logitech cordless mouse failed to drive the cursor (though it had a new battery).

The machine is not used for games/ TV, just work. My browser is google chrome.

Thanks
Kelvin
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Is it possible that you had 2 files open with the same project / module names.  I'm not sure about Excel - but Word can really struggle when that happens...

Author

Commented:
DrTribos.
I opened two excel file versions which were 99.99% identical (differing in file name and just a few lines of vba code).  Was that as fair test of your point? In the event, the files behaved perfectly regarding the operation of the tv popUp menu. But I  appreciate your suggestion.  Kelvin

Author

Commented:
DrTribos,
Also, pening the two versions in the same workbook caused no failure, Thanks.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Commented:
Well - it's nice to be able to rule some things out too I guess ;-)

The only other things I can think of are:
- it was a co-incidence, office applications sometimes crash (not very helpful, but possibly the right answer)
- were you using break'points in your code for debugging, sometimes I've managed to crash word with a carefully placed breakpoint ;-)  
- were there any other add-ins that might have been interfering with your code?

Author

Commented:
Thanks.
Will await other contributions; noted that yours was first!
K

Commented:
No worries, I'm out of ideas - hope you find a root cause. Cheers,

Author

Commented:
This was an open question, trawling for defensive ideas.
Thanks, Dr Tribos, for sharing your thoughts. As you say, maybe the crash was coincidence.
The problem did not ring any bells with others.

Cheers!!
Kelkin

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial