Is there a way to assign aMacro or VB code to a F-key such as F12,
Thanks

Hey people, I need to know if excel does have a method or function that can
find out the OS language (Windows XP) so I can adjusts paths (C:\) when
updating the fields, which are in different excels.

Hi - is there a way to call an Excel VBA procedure located in another
workbook? Thanks!

Ok my code works great except I need to start at row 11, I am not sure
how to keep it so I am only going through the current range of column
a and to be able to start at a specified row
Here is my code:

for the following macro, I want it to seach column 'c' in all sheets except
sheet4. If there is a numeric value in col 'c' of any of the worksheets in
the workbook, I want to copy the entire row to sheet 4. The code I have
written will also copy rows of data that fall between the ...

I want to do the following :
I have 1 column
Let's say the value in cell A1 is "APPLE"
Let's say the value in cell A15 is "PEACH"

At weekly meetings, a secretary of ours takes notes of what action
items are assigned to whom. She keeps track of these delegations on a
single worksheet per project at the meeting real-time, for the sake of
speed and accuracy. This workbook has one worksheet per project with

If I would like to set up 3 columns A, B, & C and would like B to be small
and just to break up columns A & C, is there a way to tab over B when
entering information from A then C?
Thanks,

Thanks in Advance for help.
i created a User Form with data box that collects the date in the
format of MMDDYYYY, i tried to validate the date with lots of code but
in the end i failed because i am a novice to VBA. i was wondering if

This might be hard to explain...
I have a useform with 24 buttons and 24 textboxes. Each button corresponds
to a textbox next to it. The idea is to click a button to open up another
userform with several optionbuttons, then click the optionbutton and have the

I am working on a form that will have 200+ rows of user input.
Each row will be the same, but seperate. Each will have 4 radio buttons
that, when selected, will display 1 of 4 drop down lists, another drop down
list, and several formulas using the values derived from the choices ...

I import data from an external source into a workbook.  Thru a macro, I sift
thru the information and delete unwanted entries.  I start out with 1900 rows
of info, after deleting unwanted information, I am left with 100 rows.
After deleting the information, how do I 'reset' Excel ...

Given the routine below, how can I have the macro seach column c of each
worksheet and if there is a numeric value in that cell copy the entire row to
another sheet (sheet2) and continue to search ?
Sub numbers()

For example, I am working on cell G8.  I would like to set up a button
that, once clicked, copies and pastes the first 10 characters from D8
and pastes it into H8.  The same process would apply if I am on G33,
i.e.copy first 10 characters from D33 and paste into H33, etc, etc.

I have a button macro that opon a worksheet(01-Length of Contract-Rollovers),
selects the sort area(Data), then sort by three criteria(K7, B7, A7). As I
record the macro to do the job it goes smoothly. As soon as I run the
recorded macro or attaches it to a button, it gives me a ...