Search results for query: *

Skip, for some reason I never had an issue with the debug button that you were able to remove and reinput and clear the problem. My issues were with either the cmbEnvelope or cmbRoofShape combo boxes. Ultimately I chose to reconfigure those into in-cell drop down lists and eliminate the combo...

Thanks for your efforts, Skip. Personally, I'm still weekday worker (another year or so) so I try to avoid thinking on issues such as this over the weekend. There are about 10 paths that end up calling FillActiveCCWindZones. Most of my hits have been as part of one of the combo boxes up near...

Here it is. See attachment.http://files.engineering.com/getfile.aspx?folder=23876b59-2eaa-47d1-b5a4-ae102dc8ba1d&file=2018_IBC.xlsm

My sentiments exactly, but why is it being called? Happens when I try to close the workbook. I am on the "CC Wind" worksheet at the time. Call stack: VBAProject.Sheet1.cmbEnvelope_Change VBAProject.Snow_WindRoutines.FillActiveCCWindZones VBAProject.Snow_WindRoutines.InitializeCCZoneArea...

The error now points to the With Worksheets("CC Wind") line. Any idea why this logic is even trying to execute when closing the workbook? Al..

I'm baffled by what is happening with this error. In reading a lot of posts on-line the normal issue is a failure to fully define a Range. In my case I believe I have defined everything and the attached logic works perfectly during the time I am within the spreadsheet. The problem develops...

If you expand out your first example you get the following: IF(OR(G4="JZ110RTK0001",G4="JZ190RTK0001") then IF(COUNTBLANK(J4)then IF(OR(G4="JZ135RTK0001") then IF(COUNTBLANK(I4)then "Failed Check 1", else "Passed Check 1" endif) endif) endif) endif) (Note in this case you...

Why number them at all, at least from a display perspective? If the numbers only appear to you as the creator and don't show on the screen when you display them who really cares what number sequence exists.

I got upgraded to a new computer at work last week and among the things that shifted was they updated my Office suite from 2010 to 2013. I have several Excel programs that in use by our production engineers and typically they use a combination of ActiveX controls, primarily combo boxes and...

I had a contract programmer once on a structural engineering program. I gave him a spec for a particular variable that was sort of the typical form, C1 = 0.5 <= some equation <= 1.0. He came over to me and indicated he couldn't program that. When I asked why not, he said it had too many...

I was visualizing a red panda with a newspaper printed on it directly.

I appreciate your story Skip. I had a mentor some 20 years ago who had an office with a low bookcase under a strip of windows. On the top of the bookcase he had stacks of papers about 12" high over the entire top of the bookcase. I came into his office one day looking for some specific piece...

Saw one over the holidays. H8 COLD Since it was a Nebraska plate my initial reaction was, "Boy, do you live in the wrong state!

Saw one the other day: PONYRDE Needless to say it was on the back of a Mustang.

Not sure about Excel, but in Word in many cases hyperlinks attach to the local folder. If you move the file without moving the files that it is linked to, you get a hyperlink that can't find the file it is looking for. If you do the full server\path\file nomenclature it should find it...

If you have something that gives latitude and longitude of each zip code reference you could run some sort of vector evaluation between two known points. Without that, I would say you are out of luck as there is no particular direct relationship between zips. The first three digits refer to...

In northwestern Missouri along I-29 there has been a truck stop for many, many years. It is at the Faucett exit and is named the Farris truck stop. I chuckle about it every time I happen to drive by.

Any reason you can't just use a hyperlink. Yes, relative referencing can be an issue. One option there if you know the address of the webpage where you are going to place it would be to use a full description on the hyperlink based on the final location of the file. Downside to that approach...

There appears to be a way to sort of set defaults. I opened a new document that is inherently linked to normal.dotm. Bring up the "Insert Table" dialog and fill in what you would like your default values to be. It normally comes up as 5 columns, 2 rows, and Fixed Column Width of "Auto". If...

Thanks for the input. I was afraid of that. I so love programs that have decided they are smarter than the user regardless. At some point in time I may play with the VBA side and see what I can dream up, but I don't have the time during this current project so I'll just keep plugging away and...