I am am trying to cause the below script to populate the date and time
fields when F8 is set to Y and not when it is set to N and to turn on and off
as that field changes without having to restart Excel each time. Any help
would be greatly appreciated.

I have created a function using VBA (below) which  assigns a vlookup value in
the calling cell.  Code is below.
Function CreateHierachy(AccountParentID As String) As Variant
   CreateHierachy = "=vlookup(" & AccountParentID & ",

I am trying to trigger a right click menu within an XLA file.  My code in my
class module is as follows below.  My class module is named "EventClass".  I
can't seem to get the menu to trigger of the right click.  The subs that get
called are in a regular module.  And I currently ...

I have the below comparison between two columns. Where the cells match, and a
different comparison of an different cell pair on the same row also matches,
it highlights a row and fills in a cell using data from its matching cell. My
problem is that, I want it so that once it's ...

I am designing a macro that displays an Open dialogue box that asks a
user to select a filename to open (in this case it’s a text file that I
am importing into Excel)
Application.Dialogs(xlDialogOpen).Show

Does anyone know how to have vbNo button selected by default when the Msgbox
open ?
rep1 = MsgBox("Would you like to add a line?", vbYesNo)
Thanks !

I'm using Excel 2002 SP3.
I have a list of 66 password protected Excel spread sheets that I need
to open, delete the top two lines, then save it removing the password,
and then move the file to a different folder.

Hello there, I have a UserForm on which there is 1 ComboBox (ComboBox1) and 3
TextBoxes (Textboxes 1,2,3). The values for ComboBox1 and the TextBoxes are
stored in multiple columns on a sheet within the workbook. (Sheet1) (Columns
A,B,C,D) What I would like to do is this: When a ...

I'm trying to take data from a spreadsheet by copying it, and then open a
new spreadsheet (that is saved on the c:\ drive), find the last row of data
in the spreadsheet, paste the data from the original spreadsheet, and then
save and close the database sheet.

If I filter and then want to select only those cells showing and give them a
range name, what's the syntax?  I tried xllastrow but that gives everything.  
I also tried putting something like ...for every activecell in range but that
also gave me everything.

In the following example:
Sub macromaster()
Call Macro1
MsgBox (Application.CutCopyMode)

Can anyone help me find out How to highlight the Top 10 and Bottom 10
Amounts in a Column? Ideally I would like one color for the top 10 and a
different color for the bottom 10.
Thank you very much!!

I am trying to create a variant array from multiple data sources then plop
that array into a worksheet.  
   Dim vaCounts() as Variant
   ReDim vaCounts(1 To 1, 1 To 3) As Variant

I am programming an Addin for Excel in VB and wondered if it was
possible to add a tab to the Options dialog that you access from the
tools menu. None of the previous addins I have seen show this
functionality, so I am guessing it's not possible?

I have a macro that is running and it is running slow since it has to wait
for the spreadsheet to do updates. I switch the calculations and it runs
faster. I am wondering if there is loss of anything. What is the difference
between the two and how does that affect calculations. ...