In Excel 2003, can't find MSForms in Reference list, in order to use:
Dim ctl As MSForms.CommandButton
Any suggestions on what I need to look for would be appreciated.
Thanks!
I usually populate a combo box in a user form with code like the one attached, but how is done with a name range. If I have a name range ("Names") in sheet2 A3:A100 with a list of personal n...
I have a need to create a utility that will assist clients in exporting flat files of product data into xml format. They want to use Excel because they are familiar with it, but the data itsel...
Using VBA - open Word and populate the doc with values from cell in Excel
Experts,
Seems like a tricky issue --
I have a change of colorIndex for a Target range in the Worksheet_SelectionChange function. Seems like right when the cells are colored, copy selecti...
i have macro in excel vba.i want that user should provide a password to access the macro.can you help me how to authenticate a user.i want code for that
Hi,
I am coding to create excel file. Here is the problem really need help.
C# CODE:
using Microsoft.Office.Interop.Excel;
string[,] saItems = new string[1, 2];
saItems[0, 0] = string...
Excel has issues with formatting numbers and auto-removing the preceeding 0's. The best way I have found to keep desired zero's in a .csv file I have is to preceed the number with a '. So '0...
Hi there,
I need to write a formula in Excel 2007 for a column called NAME. This column has values such as ;-
Request#000789
Request#000765
The formula should automatically add "r" t...
Hi Experts
I hope that you can help me as I'm stuck. I have this button that on click creates new worksheet with the name I want to. I would like to implement a code that is calling Sub which...
I can't seem to successfully insert a user defined function (UDF) into my spreadsheet. For the sake of simplicity, I've included a very simple UDF below:
Function Area(length As Double, wid...
I'm getting very frustrated working with Excel 2007 due to the alert it displays every time I open a file.
The message I'm getting is as follows: "This workbook was created in an earlier be...
I have firstname column and lastname
i have about 50 record or or rows
I what to merge name field together
example
FNAME | LNAME | FULLNAME
sam Johnson
Tony ...
In the attached spreadsheet, worksheet named 'PT' there is a column 'C' under the word blank has a load of amounts. I need to see who these amounts relate to so I can fix them so would you mi...
Hello -
We have dynamic queries running SQL queries returning a pivot table in Excel (data/connections). Users go to these reports to see the latest data available. I would like to have a c...
I'm looking to hide/unhide a row on a second worksheet when the value in a cell on the active worksheet is changed.
Here's my initial code. I'll assign some of the values to variables if I...
Hi Experts,
This question is a follow up from another question I asked before here:http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23315982.html...
Experts,
Our environment consists of Office 2007 and Office 2003. When our 2007 users utilized the IRR function to calculate an Internal Rate of Return, it would work fine. When they save...
I found the following Excel VBA macro from the Internet and it works great. It currently opens a file folder dialog window and lets you multi-select .txt files that are then imported to the wo...
Hi,
I have a worksheet of data and i'm trying to generate a report via a pivot table.
How do i generate one, any place to show me how?
Thanks.
Is there a way to highlight cells with a scroll bar? For instance if I have cells with data from 1-100 in increments of 5 from cell A1 to cell A20.. Could I insert a scroll bar from the contro...
I would like to design a macro that takes cells D69:D110 in one worksheet (data1), transposes the data and puts it in the first worksheet (Final Report) in one row. I would like to be able to ...
I have uploaded a worksheet
Basically when the department is selected on the drop drop down list. I need the data in cells
A6 a C6
A7 & C7
A8 & A8
to find and display the correct ...
Hello. I have a spreadsheet that was sent to me by someone who imported numbers in as text. I need the numbers to be converted, and simply highlighting the column and specifying the format a...
i want to write a simple macro to copy data from file(1) to file(2) (both xls) according to a certain criteria, but i don't know the syntax:
while file(1).worksheet(1).row(i).cell(j) != "" d...
