Search results for query: *

Skip, Thank you for the responses. This code works very well, but it is a nightmare to maintain and if I can figure out tables like you suggested it will help when it comes time to change something. Answers to your responses: 1st response: I will look into the lookup tables and see if I can...

My apologies for such a long post, but this is a long formula and I would like to see if anyone can make suggestions to shorten it. I would post the entire spreadsheet, but I do not have any public space. It is a year-long timesheet consisting of 13 tabs - 12 months (Jan-Dec) & and 1 Months...

PH & Skip, I typically avoid using the Sheet Name and use what I now know is the Sheet CodeName so I started at the first textbox object in the UserForm and looked at the Properties Window and noticed that ControlSource is referencing 'WTS by Ext'!b1 (the name did change from 'Fueling by...

Thanks Skip When I change all code to Sheets("sBUxExt").expression I get run-time error '9': Subscript out of range. When I change all code to sheet1.expression I get run-time error '424': Object Required Since I don't know how to copy the Properties Window here's a text representation...

Thanks for the reply PH. I know my post was long, in the paragraph after "If I click end" is: If I click Debug it takes me to the ThisWorkbook Workbook_Open event at the line - Call sBUxExt.UserForm_Initialize; but it won't let me proceed until I stop and click design mode, then again I can...

I have a spreadsheet with a vbModeless UserForm that works for one business unit. When I open this spreadsheet and Save As to a different name I can close it and open it with no errors. But if I double-click on the first tab and change the tab name for another business unit then save the...

Out of curiosity. Is there a way to float the control objects as the page scrolls?

Beaver, Thanks for your reply. I don't know why setting the value to 3 didn't work, but I tried it again after your suggestion, but it wouldn't take. However, using Skip's suggestion, I selected all of the objects and followed his instructions and viola. Thanks to both of you for your...

I have an excel spreadsheet that has several command buttons to the right of the data which is in columns a:i. If I apply AutoFilter and select to hide data on the same row as the command button the command button gets hidden as well. I found through research that the Placement attribute 3 is...

That did the trick. Sorry for the delay. We're changing domains, IP networks, email servers and telephones...this is the first chance I have had to try your suggestion. Thanks, Charlie

I have the following vba code in an Excel spreadsheet with a cmdButton. When I click on the cmdButton I get an error that the file to be opened does not exist. When I step through in debug mode the file is created. I'm using the redirect output character ">" in the shell(cmd) which should...

I was just trying to explain that I did search for threads on conditional formatting before I posted this thread. And I didn't find the thread Geoff listed because I was too restrictive with the keywords I chose - "excel 2003 conditional formatting". So, I guess I need to be more general on...

Exellent examples Geoff, I kept searching for "excel 2003 conditional format" and didn't see the thread you listed. I'll try to be a little more diligent in my searches. Thanks for the info! Thanks Skip for your info, too!

Skip, Thanks for the info on Format Painter. But I meant to ask if I could automate the process in conditional format 1 of cell C2 (for example). So that I could have 1 conditional format statement that would match the value of cell C2 (HOL) from an array (e.g. X1:X20) and apply the color of...

I have a calendar for keeping track of employee time. I have several categories for not working on a weekday - Holiday, Plant Closed, Vacation, 1/2 day vacation, etc. Each of these categories need to be color coded, but conditional formatting only allows 3 conditions. Currently, I have the 3...

wow...that did the trick. Thanks strongm!

Thanks for your reply strongm. That worked until I came across a 3 GB file, the result went negative. Any ideas?

I am writing a VBA script in Excel 2003 to find all .pst files and their pathnames on the Network drives. I have the names, paths, but cannot find a property for the file size. I want to collect the file sizes so I can determine how to best fit them on a DVD for storage so I can get them off...

That's what I thought. Thanks for replying.

I have an Excel 2003 spreadsheet that has a dozen columns. Depending on the request the spreadsheet can be sorted logically by 4 columns. When you click on Data, then Sort, the column header selected last is still listed. I would like to create a Page Header containing the words "Sorted by...