42290 posts
23030 users
Hello, I have made a ActiveX control which consists of some textboxes and a button. Now I am trying to use this control in Excel, with the help of macros. I have used ActiveSheet.OLEObject.Add to...

Nikhil Joshi
Just released: Excel 2007 XLL Software Development Kit
15 replies , 9/11/2007, 11:56:09 PM
The Microsoft Office Excel 2007 XLL Software Development Kit is out the door at long last. Many Excel developers have been waiting for the new XLL SDK for a long time now, since we released Office...

Danny Khen [MSFT]
Count Textboxes and other objects
1 replies , 10/10/2007, 10:01:16 AM
Is there any way that you can count the number of textboxes and other drawing objects in a sheet using c# or VB from an application and change their contents?

Distributing All Days Across Months by CPearson
1 replies , 7/3/2004, 8:01:44 AM
The formula below I have used in my worksheet is what I have copied from Mr. Pearson's site http://www.cpearson.com/excel/distribdates.htm (Many thanks to him and his great site), however it is based...

Distributing All Days Across Months by Chip Pearson
2 replies , 7/3/2004, 8:30:28 AM
The formula below I have used in my worksheet is what I have copied from Mr. Pearson's site http://www.cpearson.com/excel/distribdates.htm (Many thanks to him and his great site), however it is based...

Displaying bivariate frequencies...
3 replies , 10/15/2004, 11:59:50 PM
Say I have two columns of data in Excel as follows: A B 1 1 1 2 1 3 1 1 1 2 1 3 1 1 1 2 1 3 1 1 1 2 1 3 2 1 2 2 2 3 2 1 2 2 2 3 2 1 2 2 I would like to be able to generate the following on an...

Macro or Formula needed to search data in cells
3 replies , 5/5/2005, 4:57:16 PM
Hi I am looking for a way to create a formula/macro to do the following: My worksheet setup: A1:A30000 C1:C5000 01 02 03 04 05 06 07 08 09 10 01 04 05 06 08 09...

Hi I've been trying to construct a Duplicate entries/Lookup superformula all to no avail. Column A is a helper range (optional). Column D contains strings of numbers and/or characters. I wish to...

COUNTIF function question...
10 replies , 5/7/2005, 12:43:58 AM
Greetings, So I have a spreadsheet where we enter customer data and then we use a COUNTIF on another sheet to count several categories (Sales Rep, type, etc). What I am trying to find out is if I...

Revisited - Balloon Loan help
2 replies , 5/11/2005, 7:44:08 PM
I am looking for some additional information on balloon loans; and would like to create a spreadsheet to help me analyze offers relating to an automobile purchase. I found this excellent template...

Robert Neville
Hide rows depending on content...
1 replies , 5/12/2005, 1:02:55 AM
Is there a way to hide a row of a sheet unless there is something in a certain cell? I have a list of CountIF's and some of the cells are blank to have built in expansion. Until the items are...

I have a simple worksheet to amortise a loan. I would like to use a formula to extend the rows downwards to the number of payments (Number of years x Number of payments per year) using a...

Using sumproduct while skipping cells in the array
4 replies , 1/30/2007, 2:37:46 AM
I'm trying to use sumproduct in a situation with two arrays of numbers. It works in the place where the arrays are contiguous, looking like sumproduct($A7:$A15,C7:C15). However, in one place one of...

Excel 2003 & Template Wizard
0 replies , 10/7/2003, 7:35:49 PM
We have been using the "Excel 2002 Add-in: Template Wizard with Data Tracking" to send data from our Excel spreadsheets to an Access database. We just recently installed Office 2003 and now the data...

Mike McNamara, P.E.
formula question, parentheses (sorta newbie)
2 replies , 1/20/2004, 12:22:48 AM
I've used Lotus 1-2-3 and Quattro Pro for years, and I'm somewhat new to Excel. I'm using "Microsoft Excel for Windows 95 / Version 7.0". When I enter a formula and the cursor is anywhere near the...

PERSONAL file automatically opens upon starting Excel
7 replies , 4/15/2004, 8:24:22 AM
I am a newbee in writting Macros. I wrote one and now after that whenever I start Excel, a file opens with file name: "PERSONAL". I went to following folder: C:\Documents and...

Rasoul Khoshravan Azar
I use Excel with both European and U.S. data and number formats. I know I can change this setting using Tools/Options but as far as I can see this affects all worksheets. This means I can't have two...

Willy Verwoerd
Error message with embedded objects.
1 replies , 11/19/2004, 2:23:42 PM
When trying to open an embedded Word document from within an Excel file I get a message saying: "Cannot start the application required to open this object, an error occured and this feature is no...

Sabrina D
Deploying =?windows-1252?Q?=93Analysis_ToolPak=94?=
5 replies , 1/11/2005, 6:08:57 PM
I have used group policy to deploy Office 2003 to a lab environment. I want to make available for all users, by default, the Excel Add-in �Analysis ToolPak�. What is the most efficient way to...

Will Butler
Excel error - Startup (and Acrobat PDFMaker)
0 replies , 2/4/2005, 3:44:46 AM
This must be such a common error, that I'm surprised it's not explicitly "detected" by Excel on startup. Error symptom: Excel 2003 cannot open any vintage of .XLS file, and even on invoking...