Search results for query: *

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...

This is kinda weird. I have a userform with a couple dozen controls - a number of them comboboxes. The user enters a value in text field 1. The logic in the AfterUpdate event sets up the combo boxes with values and sets a starting value. There are about 5 combo fields it does this with...

Thank you to all who have responded to date. I worked on this over the weekend and came up with an approach of inserting an intermediate text control. So: ComboF1 txtSwitch ComboF2 ComboF3 ComboF4 ComboF1 sets the enabled property of F2 & F3. Then the tab order takes us to txtSwitch where I...

Sorry I forgot the question. It is: Why is this not doing what I expect? I built an Excel 2010 workbook with a single command button to open a user form. The user form has 4 combo boxes labeled comboF1 thru comboF4. A listbox tracks firing of events but it is optional. Here's all the...

More interesting stuff. The tab order is: Start Stop Duration All fields are enabled. In the AfterUpdate event for START is say if the control is empty then disable STOP. If the control value is not blank then enable STOP. I go to the START field. I enter a value and TAB. We move to the...

The simple idea of moving from control to control is driving me nuts. I have 3 fields: Start Time Stop Time Duration Here are the rules. We come to the start time field: 1. When we leave if the field is blank then skip Stop and prompt for duration. 2. When we leave if the field is not...