Excel/Cellphone01846 (6/7/2010 8:59:45 PM) CharlesHi,
I would like to know if it's possible to program Excel to send Text
msg to Cell Phones.
Floating text11463 (6/7/2010 8:33:18 PM) UtfHi everyone,
I'd like to have some question+answer showing up on top of all my
applications() to make me read it and memorize it.
I know that I can hide Excel, but how can I hide the form but the text on ...
Macro if criteria21191 (6/7/2010 7:47:33 PM) UtfHi, i have two macros. (macro 1 and macro 2)
I need macro 1 to run if in A1 is "JOHN", in B1 is "MARY" and if C1 is empty
; and macro 2 to run if in A1 is "JIM", in B1 is "CRIS" and in C1 is "BOB".
VBA Code to select and format range22435 (6/7/2010 7:11:04 PM) UtfHi All,
I want to select a range of cells and format the range of cells based on a
The last couple lines in my code are:
Compare two columns using loop.12305 (6/7/2010 4:03:50 PM) UtfHi,
Could you please help my create a loop which will compare each value in
column A one by one with whole column B whether it contain value in column B
and if yes the it picks up value from column C and...
Code not working in a PROTECTED Worksheet21276 (6/7/2010 7:33:18 PM) UtfI have the code below in a worksheet on a file in SharePoint. The worksheet
is Protected so only unprotected Cells are selectable. The problem I am
having is that when the sheet is protected I get an error ...
External Data from SQL Server11399 (6/7/2010 7:41:16 PM) UtfI have a worksheet that is importing data from SQL Server. MS Query is
configured to execute a stored procedure.
Sometimes when I refresh the query with new parameters I lose formatting and
Automatic Prompt for Users to Save8767 (6/4/2010 1:44:55 AM) UtfI have an Excel 2007 workbook that is populated by an Access table. Once the
data is transferred to Excel, Access opens Excel so we can view the data. I
would like to have the Excel spreadsheet then promp...
open several workbooks at the same time151190 (6/5/2010 4:47:35 PM) Johnnyboy5I would like to repeatly open the same workbooks at the same time just
by selecting just one book and the other three or four will open with
Drop Down with hidden values11560 (6/7/2010 5:29:29 PM) UtfI need some assistance please. I have a spread sheet that I have drop down
information on. When the user selects the word from the drop down list, I
would like for the word to have a numerical value to it...
Can use VSTO to reduce the size of a file?01092 (6/7/2010 6:06:13 PM) UtfI have a really large spreadsheet that is saved in a sharepoint location but
takes about five minutes to load.
Would it make any difference if I recreate the file using VSTO?
Thanks in advance
Worksheet Cell Reference1876 (6/7/2010 5:17:00 PM) UtfI have a reference to a cell in another worksheet, same workbook. When the
value in the referenced cell is blank it returns a "0" value. However, I want
the returned value to simply leave as a blank cell. A...
When this NG migrates to forums, please consider ...0648 (6/7/2010 5:22:06 PM) HenryMany of the questions in this NG fit into the following template:
My [boss/teacher] gave me this problem that would be really easy to solve if
I had a clue about VBA programming but I don't. Would someone...
Solver01014 (6/7/2010 5:16:56 PM) UtfHi Group,
I am having a hard time programming Solver. This is the code I have so far:
Compare and Copy/Paste b/w Two Workbooks17843 (6/3/2010 7:56:46 PM) UtfI have this macro that compares values in two columns (A & M) in the same
sheet and if there is a match, it takes the value in the adjacent column (N)
and pastes it into ColumnE.
Using counter "i" in for loop gives error4882 (6/7/2010 7:01:41 AM) peterFellow excel programmers,
I have the following little program which gives me an error:
' code Macro
' Keyboard Shortcut: Ctrl+o
For i = 1 To 5
ActiveCell.FormulaR1C1 = &...
Graph not plotting correctly if source not selected51981 (6/6/2010 5:12:40 PM) FrankHere my code:
Set Cht_level = Charts.Add
.ChartType = xlLine
But if I
before the code, it works brill...
Macro to run based on criteria21344 (6/7/2010 3:48:46 PM) UtfHi, i need a macro to run based on a criteria in A1.
In A1 i have a dropdown list with sheets name. If i select in A1 the sheet
John, and then i run the macro, i need the macro to copy some cells from the
Multipage, controls-collection and events (XL2003, VBA)02020 (6/7/2010 4:06:05 PM) HolgerDear Group,
I have a Userform with a Multipage control, which is dynamically filled with
textboxes and comboboxes using Controls.Add like this:
Set aTextBox =