Recent content by dean12

Aw, spoke too soon. It doesn't work after the export/import. I guess I must have clicked the task combobox twice by accident. That's one of the strange symptoms. Click the drop down and select and you get nothing. Click again and select and it works. OR: click in the text area of the combo...

Well heck, export the userform, import, and it works. I could swear I tried this. Blasted Excel.

Yea, I'm really starting to think this is some sort of screwup within Excel and how it is storing stuff. I started deleting userforms, retrying the combo boxes, and got to a point where it worked. So I backed up to my starting point and deleted that userform which caused things to work and lo...

Continuing...I cut everything off the userform except for the proj & task fields. Cut the code down to the bare minimum. It still fails. There are only the two controls on the form. For what it's worth the entire code set for the user form is: Option Explicit Private Sub...

I'll check but I don't think so.

Yea, good idea but it doesn't seem to help. I tried DoEvents in a couple of different places ComboProj.AfterUpdate populateComboTask but no change. And the crazy thing is there are items in the combobox, I know that for usre, and Windows highlights the item as I mouse over it but click...

Excel, you're killing me! I originally posted thread 707-1651774 about a year and a half ago and I still get bitten by VBA. So I have 2 pairs of combo boxes: SI & Step and Proj & Task I populate comboSI. The user selects an item. In the AfterUpdate event I populate ComboStep. What goes into...

I've got a bunch (100 or so) DLL files. I would like to create an Excel sheet that shows: Assembly Path & DLL name Namespace Class Name I can use VS2010 to get this information or ILDASM but in each case the information is not readily convertable to my 3 column Excel sheet. The best I seem...

Yea, sadly Pivot tables let you add information 8 ways from Sunday so summarization before hand is not possible. Geez, its amazing how limited Pivot tables can be.

Working with Pivot tables today. The data is simple: Category Hours So we might have: Category Hrs Work 8 Work 8 Vacation 8 We want a pivot table with rows being the Category and two columns Hrs and % of total Hrs. We get Category Sum Hrs % Work...

Maybe but I don't think so. Besides, I can go and right click on the thing and select 'shutdown' and I don't get an error.

So I've got this little VBScript that tries to shutdown a COM package. 100% of the time it does that. About 50% of the time it also throws up an error: "An unhandled win32 exception occurred in dllhost.exe [8616]." Then it wants me to go into the Visual Studio Just-In-Time Debugger. I...

mintjulep - you would need to read thread: 707-1651274 (Userform controls - SetFocus) combo - many folks here talk about the CHANGE event. My tests show that this event fires every time the user types or "changes" the value in the control. If that is true when do you know the user has...

only about 1,973 lines

Imagine a userform with 3 text controls. We are in text field 1. We type something or we don't. Hit tab and we move to text field 2. In text field 2 I want to do some work but I don't want to be left there. When I finish working I want to move on to text field 3 without the user having to...