The following doesn,t work and I have no idea why - any suggestions?
I am assuming the code should run when the worksheet "Data Input" is
selected.
'Code in Sheet1 "Data Input"

i ran into a web site
http://theopensourcery.com/vbover.htm
which states that VBA is facing a slow & painful death.  :0
granted, the info seems to be <2005, so here it is 2 years later & VBA

The GetOpenFileName function creates an Open common dialog box that lets the
user specify the drive, directory, and the name of a file or set of files to
open and access.
Is there a similar function in Excel that lets the users specify which

I've tried to read data column from excel to access but could not get it
done. Can any body assist?

Is there a way to format cells containing integers such that:
a) they show up as roman numerals, i.e., I, II, III, IV, V, etc.; **AND**
b) that numbers like V have both an underscore & an "overscore", i.e., a line
   across the top as well as across the bottom?

Hello from Steved
Is it possible please to combine the 2 below macros into 1 macro. Thankyou.
Sub AddNameNewSheet2()
   Dim CurrentSheetName As String

I have an application that has been in use for many months, but today a new
problem began occurring.  The workbook has numerous combo boxes, checkboxes,
and option buttons linked to cells beneath them with the linkcell property.  
When I select the value, it fills in the cell just ...

I have an interesting project to work on and I am not quite sure what
the best method to attack it would be.
I have two sheets.... 'Footages' and 'Breakdown'
Footages is a general line item description with footages for each

I need some help in figuring out how to get Excel VBA to filter a
record for a specific month.
I'm trying to code a macro that will generate a list of all employees
born in a certain month and Excel keeps adding 2007 to my filter.

I hope someone can help me... I'm trying to create a worksheet in
excel where the user inputs a number and a result shows in the
following cell. I want to create a button where when they click on it
the button copies the result into the clipboard and at the same time

I have the following code.
Do Until ActiveCell.Value = "End"
   Range(Selection, Selection.End(xlDown)).Select
   Selection.DataSeries Rowcol:=xlColumns, Type:=xlLinear, Date:=xlDay, _

Windows 2000, Excel 2003
How do you get excel to use a fraction as a fraction and not a date?  I am
using a function that returns a fraction as a string.  I then copy it and
paste it in a new cell as value..  I have tried formating the cell as a

Help!  
I dynamically add a worksheet during code execution in a module.  I need to
also add a feature so that the user can toggle between hiding or displaying
individual rows of data.  I'd thought of adding a toggle button but then

I am trying to create a shortcut method for toggling between Auto/Manual
calculation mode.  I have two menu items, one in the right-click menu and
one off of the worksheet menu.  As part of both menu items, I update the
.State property based on Auto or Manual.  In order to make ...

I have a very large spreadsheet created in Excel.  I am trying to alternate
every other row grren and then Pink.  However, I can't seem to figure out how
to do it other then doing it by each individual row.  Is there a way to do
this by highlighting what I need to alternate and ...