Hi, this must be a pretty basic question, please excuse
my lack of knowledge.
I right click a cell in Excel, select Format - Text.
Next double click the cell and enter a hyphen.

How do you extract and use the data capture by Inputbox functionality?  I'm
developing which solicits data via questions.  I am trying to use the data
captured to populate worksheets within the file.

i have assigned a macro to the print command, (filename is file1.)  if i open
another excel spreadsheet (book1 or filename2,) the macro is still assigned
to the print button.
can the print button be reset to set the default command (print)after the

In the worksheet, I have cells of different formats - color,
validation, font etc and I wonder if there are any routines to restore
both cells - both the "drag from" area- and the "drop to"- area.
Maybe you can use Selection_change event to remember the "drag from"

I am trying to setup so I don't have to select the library in
Tools/references. I get "Run-time error 429: ActiveX component can't create
object". Isn't that correct to setup for a late binding?
   Dim OutApp As Object

I have developed extensive Excel 2003 VBA addins.  I'm planning my Excel
2003 -> 2007 upgrade and have a couple general questions to start with:
1. Will Excel 2003 addins work in Excel 2007?
   I hope I can load my 2003 addins in Excel 2007, save them and

I tried to figure out how to make the code that JE McGimpsey has posted on
his site: http://www.mcgimpsey.com/excel/timestamp.html "DateStampMacro" but
just do not have the VBA skills to decipher how I need to change it to work
for me.

I have 2 questions on ODBC connection.
First, is it possible to use VBA to setup the ODBC connection to link to an
access db located on each person local directory (same directory for all
users). If so, can I get some example.

Using Excel 2003, I have a VBA program that I use to do Monte Carlo
analysis.  Sometimes I run it for an hour or two.  My one gripe with it is
that it hogs the whole machine and makes it difficult to use other programs
in the foreground.  Generally I run it at night and don't ...

I have a couple of applications that use ADO to update recordsets (SQL) from
an excel interface.
After opening a recordset, I set it to the beginning of the file and then do
a find.

I'm having a bit of trouble with a Save As file dialog.  The problem is that
I'm creating a copy of a workbook and it's the new copy that I want to "save
as", but the original workbook is the one getting saved!  Can anyone tell me
how to ensure that the copy gets saved and ond ...

Here is my code:
   Range("A6", Range("G65536").End(xlUp)).Select
   Selection.Sort Key1:=Range("G7"), Order1:=xlDescending, Header:=xlGuess, _
       OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _

I have a list box on a user form that is populated with several sheet names.
If you don't select anything on the list, I want to send a message to the
user that he didn't select a sheet.  I have one list box where the code
below works, one where it doesn't.  I am using the ...

On Sheet1 I have cells linked to cells in Sheet2, Sheet3.... (I did Copy and
Paste Link). With about 20 sheets in a workbook, it gets difficult to go
between Sheet1 and the rest of the sheets.
Is there a way, e.g. double click on a linked cell on Sheet1 to activate the

For one of my user-forms, I have a combo-box.  The rowsource property
contains a formula using OFFSET function that refers to existing areas in the
existing workbook.
When the form is displayed, the ROWSOURCE works correctly, and the drop-down