I am having problems with my find match function in VBA, this workbook
is linked to another workbook, and the reference cells come from that
workbook, this doesn't always calculate because there has been no event
that triggers the calculation,

I have a spreadsheet which I share with four other people, and I need to
have their login username (the variable is called sName) as part of their
data entry. What I need is a way to fix the following problem.
Their last line of data entry is a Time variable which is entered into

I posted on this topic a month ago but have had no reply.  Can anyone
confirm this bug in Excel?
To reproduce the bug:
1. New workbook

Hello, i want to delete a string from another string, like the example
below:
variable: "daniel" - "niel"
so in my variable i would have "da"

i am new to excel programming
i am in sheet1.. when i click a button i should go to sheet5...
kindly send me the coding ... i will be thankfulll

I have a column where are values 3,2,1 and I want to make a "traffic
light" indivator out of them. 3 is green, 2 is yellow and 1 is red. If
the cell is blank, it means yellow.
I made 3 ovals on the sheet.

Howdie,
Is it possible to create a form that when you click a button runs a
Macro based on the contents of what has been entered into a form?
If yes...Any ideas how... ?

Hi Everyone..
I am Java Developer and have no idea how VBA works.. I have the
following excercise need to be done asap part of my MBA... Would anyone
can help and get me started or write it fully for me and I can pay some

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("d17").Value > 0 Then
Application.EnableEvents = False
Range("a5:o17").Select

I have created a VBA application that prevents users from being able to
open an Excel spreadsheet without first accepting the terms &
conditions, sent to about 1,300 users.
I have 2 versions, v1 appears to work fine, with v2 (which prevents

Just a quick question that I couldn't find an answer to after searching
because of how often the words "true" and "false" appear in different
threads.
How, with VBA, can I reverse a cells value from True to False and the

I am trying to copy a cell that has both regular text and subcripts
(effects).  When I copy it, the new cell only shows regular sized text.  I am
trying not to retype these cells because my program is rather lengthy and if
a title changes, I would like all of them to change in ...

I wrote some scripts in excel 2000 that used web query and yahoo
finance quotes.
Trying to run the scripts in Excel 2003 is a nightmare. The script
below works fine in

 I have posted this question already in the group with no results.
Now, I have done some of the macro but please help me on what is
missing.  Thank you in advance.
 I have an excel sheet in which it has a column full of paths of Word

How do I expand this macro from ABC to A+ A B C D?
Public Function ABCRank(Test_Value As Single, Test_Range As Range,
Upper_Cutoff As Single, Lower_Cutoff As Single)
Application.Volatile