Programming

Excel Programming
Could anyone suggest a good book for learning to program in Excel? Macos etc. ... 18 Jul 2008 16:31

Replace microsoft forms message box with something more meaningful
Hi I have a userform with a combobox whos "match entry" property is set to True. If the user enters invalid text they get a microsoft forms message saying invalid property value. How do I change the message to something more meaningful. I would be grateful for any help Kenny W XP pro and Office 2003 ... 18 Jul 2008 16:31

Separating information in a text string
I have imported information from an AS400 into an Excel spreadsheet. I need to separate the employee name field. Currently the name field is "Brown, Oscar J". All names vary in length. What is the easiest way to split this into separate columns under Last Name, First Name, and Middle Initial? ... 19 Jul 2008 12:58

If, Then, Delete Entire Row, Loop, End
Hi, I appreciate your help. I need to run a conditional If Then statement on a defined table. If the cell in column 1 is blank or null, then delete the entire row, and run this statement on every row until the end of the table. Thanks again!, JC ... 18 Jul 2008 16:31

how to append and remove dups
hi! I have the following spreadsheet: columna columnb columnc columnd 1 AAAA BCBCBC xyxyxy 1 AAAA DEDEDE sdsdw 2 DDDDD ghjhedt jhughu 2 DD... 18 Jul 2008 16:31

Comparing two spreadsheets to analyze changes
I am needing to compare two spreadsheets - one for the previous month and one for the current month. I need to find the unique IDs that are new in the current month's file and also find those who had more than a $25000 difference from the previous file and so are on both files. ... 18 Jul 2008 16:31

Similar Cell Data Comparison?
Is there any function or add-on that can allow me to compare two cells and provide some type of similarity score? Would like to determine matches such as "John Smith" to "Johnny Smith Jr.", or "5006" to 50006" at to flag those rows some how. Thanks for any ideas. ... 18 Jul 2008 16:31

Query website from spreadsheet
I have used web queries before but never tried to do anything like this... I have a spreadsheet with a column of URL's. What I would like to do is write a macro that can loop through the "URL" column and query each website for the contents of the meta description tag and store that in an adjacent cell. i.e. A... 25 Jul 2008 10:26

Question about linking Access to Excel.
Hello, I have a access database that stores all the tables and the queries that I want to dump on an excel sheet. On the excel sheet, I want to create a button call Refresh Data & Calculate Report, so whenever the user opens the excel sheet and clicks on the Refrest button, the new data that has been stored in Ac... 18 Jul 2008 18:34

Adding Labels to a XY Chart
Hi All, I am trying to write a chunk of code that adds labels to my XY chart. Basically I code is very simple ActiveWorkbook.Sheets(pChartSheet).SeriesCollection(1).Points(199).DataLabel.Text = "199" That line works fine, but ActiveWorkbook.Sheets(pChartSheet).SeriesCollection(1).Points(200).DataLabel.T... 19 Jul 2008 14:00