Trigger Event Sub when A1 <> B1
Let's say I have values in two cells, A1 and B1.
A1 contains a fixed value. B1 displays a value from a DDE connection to a
communication server that pulls data from a particular device. The value in
B1 can change at any time.
Under normal circumstances, B1 should always be equal to A1. If B1 changes
and is no longer equal to A1, this indicates an alarm condition and I would
like this condition to trigger a VBA Sub which will include some code to
process the alarm.
So far, the only way I think of doing this is by responding to the
Worksheet_SelectionChange...Creating a list of info in A1 cell in multiple worksheets
How can I create a list of the info/contents in the A1 cell in multiple
worksheets? I am trying to create a summary worksheet of the data from 90
worksheets and would like to be able to list the headers in the A1 cell
'Right click on the summary sheet tab, and paste in this macro.
'Edit where appropriate:
'Starting row for summary:
i = 1
For Each Sheet In ThisWorkbook.Sheets
If Sheet.Name <> Me.Name Then
'Control What column to place data in
Me.Cells(i, "A").Value = Sheet.Range("A1").Value
i = i + 1...If E9 Is red then place tommorrows date in A11
XL-2000 Is there a formula that can
If E9 Is red then place tomorrow's date in A11
or If E9 Is green then place tomorrow's date in A11
Is this a typo or did you mean "if E9 is green or red place tomorrow's date in
Perhaps one of the "tomorrows" should be "today".
How does E9 get to be green or red? Conditional Formatting? If so, use the
same condition in a formula in A11.
If you manually format E9 to be green or red, you will have to use VBA to
return whichever date in A11.
Some more detail maybe?
Gord Dibben Excel MVP - XL9...A1-A2/A2, A2-A3/A3, A3-A4/A4...etc. how do i do this for the whole column?[/
*A1-A2/A2, A2-A3/A3, A3-A4/A4...etc. how do i do this for the whol
Johnny3's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1675
View this thread: http://www.excelforum.com/showthread.php?threadid=31958
> *A1-A2/A2, A2-A3/A3, A3-A4/A4...etc. how do i do this for the whol
If I understand your post correctly, enter this formula in Cell B1
and copy down as required
----------------...How do I rename my columns? (i.e.
Just trying to get specific info at the top of my spreadsheet where (A1, B1,
C1....etc) are. Not sure quite how to do it. Any assistance would be
appreciated. Thanks in advance.
You cannot rename the columns, you can use the first row to enter your names
> Just trying to get specific info at the top of my spreadsheet where (A1, B1,
> C1....etc) are. Not sure quite how to do it. Any assistance would be
> appreciated. Thanks in advance.
Use row 1. If the A1, B1, bother you, Tools - Options - View, hide column
...IF value = 5 then change cell A1 else change B1
is it possible for me to change the value of another cell using the IF
and else statements???
mkwazeeri's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27222
View this thread: http://www.excelforum.com/showthread.php?threadid=467356
No. You'd have to put an IF in A1 and B1.
"mkwazeeri" <firstname.lastname@example.org> wrote
in message news:mkwazeeri.1vbqqd_1126659950.5675@ex...how do i mark range from A1 to DV5000 without scrolling?
Is there a menu option to mark a range from A1 to some far off cell
like DK4563 without scrolling all the way down and across?
You can type the address, e.g., A1:DK4563, in the Name Box, which
is to the left of the formula bar. This will select the specified
Microsoft MVP - Excel
Pearson Software Consulting, LLC
<email@example.com> wrote in message
> Is there a menu option to mark a range from A1 to some far off
> l...Load Excel with focus on A1
I have a spreadsheet containning multiple sheets. I would like to be
able to load the spreadsheet and to have all sheets with focus on a1.
Is there a code i could put in Myworbook or is there something else I
could do to have it automativcally load with focus on A! each time. The
reason why is that many people do view the spreadsheet and when it opens
I need to be initialize to A1.
Fabiolus's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28340
View this thread: htt...how to stop repeating a number in worksheet(e.g. cell A1 is 6655 .
I want to to know I can stop a number to repeat in excel worksheet. (e.g.
cell A1 is 6655 so 6655 should not repeat inwhere in the worksheet of even if
it appears there could be a pop up massage says number repeated in cell# A1)
You can use data validation to prevent duplicates. There are
And to include a message, add an error alert or input message:
Mushtaque Parker wrote:
> I want to to know I can stop a number to repeat in excel worksheet. (e.g.
> cell A1 is 6655 s...Sorting a1,a2,a10,a11
What can be done to have this sort as above as opposed to a1,a10,a11a2.
Only by using a help column that will extract the numbers and sort by that
help column ascending
"Arturo" <Arturo@discussions.microsoft.com> wrote in message
> What can be done to have this sort as above as opposed to a1,a10,a11a2.
...Window resets to A1 when entering data
I'm using Excel 2004 for Mac on a MacBook Pro with OS 10.5.8. When I go to
enter data into a cell, the window automatically moves so that A1 is the
uppermost left cell. This is very frustrating because I then have to find
the cell I was entering data into by scrolling all over the place. Any ideas
on why the cell I'm entering data into won't stay in view?
not sure never seen a mac, but does it only happen in one workbook on one sheet?
do you have any code on the code page?
"Mac User" <Mac User@discussions.micro...What if I wanted to combine a1 b1 c1 d1
What if I wanted to combine a1 b1 c1 d1? How do I do that
Message posted from http://www.ExcelForum.com
see your other thread.
P.S.: please stay in your original thread
> What if I wanted to combine a1 b1 c1 d1? How do I do that?
> Message posted from http://www.ExcelForum.com/
No need to multipost, Frank has already answered your first post, and you should
have been able to use that example and simply expand on it by including C & D in
the same manner. It's not going to break it if you try it. :-) ...IF the date in A1 is a holiday, cell B1 should say "HOLIDAY"
Here's what I want to do but I'm too dumb to it. Usually I Google
before asking here but my Internet is down though NGs and email work.
In cell A1 we enter a date, say, 07/22/04. If the date in A1 is a
holiday I want cell B1 to show the word HOLIDAY. If A1 is not a
holiday, B1 should be blank. I will list the holiday dates in cells D1
Part 2 is the same as 1 but instead of the word HOLIDAY appearing the
name of the holiday, NEWS YEARS DAY, will appear. I will list the
holiday names in cells E1 to E10 next to the dates in column D.
=IF(ISNUMBER(MATC...how to get rid of Comment [A1] in my documents?
In a 300+ document I occasionally get a long "balloon" type thing with
"Comment [A1]" (or other number) in it and I cannot get rid of it, nor do I
know what it means. HOW do I get rid of it? I use Word 2003.
On the reviewing toolbar (View > Toolbars > Reviewing) Show > Balloons >
Check 'never'. Or right click the comment balloon and select 'delete
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gm...Operator precedence (order of operate) =A1/A2*A3^5-(A1+A2)
what is the order of operating and calculating in this formula?
If it were me, I'd put parens in to ensure I get the calculation I want.
"Masood Shahab" <firstname.lastname@example.org> wrote in message
> what is the order of operating and calculating in this formula?
> 1- A1+A2
> 2- A1/A2
> 3- A3^5
> 4- A2*A3
Masood Shahab wrote...
&...Excel help should explain how to change r1c1 to a1
Help describes a1 and r1c1 referencing but doesn't tell how to switch from
one to the other. Can anyone help?
tools>options>general and uncheck/check R1C1 reference style
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"schlimgen" <email@example.com> wrote in message
> Help describes a1 and r1c1 referencing but doesn't tell how to switch from
> one to the other. Can anyone help?
Click on Tools...How to fill cells A1, A2, A3... with contents from B1, B4, B7...
I am trying to copy contents from, say, B1, B4, B7, .... into A1, A2,
A3,.... And did not know how to set up a formula to do that. I'd appreicate
for any suggestions.
If you're trying to copy every third row from B to A, enter the formula
=OFFSET($B$1,ROW()*3-3,0) in A1, and autofill down through the appropriate
cells in column A.
> I am trying to copy contents from, say, B1, B4, B7, .... into A1, A2,
> A3,.... And did not know how to set up a formula to do that. I'd appreicate
> for any suggestions.
I'VE ACHANGEABLE NUMBER IIN a1 AND I PUT IN b1 "=MONTH(A1)
IN ORDER TO GIVE ME THE MONTH'S NAME WHEN I CHANGE THE NUMBER IN
A1 BUT IT DDINT WORK
THANXXXXXXXXXXXXXXXX FOR AL
frsm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3123
View this thread: http://www.excelforum.com/showthread.php?threadid=51453
I believe you have to have a date in A1, not just a number.
"frsm" <firstname.lastname@example.org...A1=B1 plus or minus tolerance!HELP ME PLEASE!
hi all! can anyone help me!
below is an example of what i am trying to achieve but cannot find th
correct formula to do it.
in cell (a1) the number 2470.56
in cell (b2) the number 2471.32
i know there is the formula (a1=b2)would give you a true/false answer.
but what i am after is for the a1=b2 to have a plus or minus toleranc
of say 2 points or the number 2.
so that the above numbers in cells a1 and b2 WILL EQUAL each other an
give a TRUE answer rather than a FALSE answer.
obviously if the numbers were more than 2 points apart then the answe
WILL BE FALSE.
can anyone help me it would be gre...How can I use Schedule + Priority in the New To-Do Bar eg A1 A2
I have used the field Schedule + Priority in the older version of Outlook in
the Calendar Task Pad and found thsi a very quick way of adding a task with a
Priority A1 A2 A3 etc. How can I do this or achieve the same result
I get it when I concantenate cells made of text strings
please tell us what is in each cell prior to concatenation
bob777's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28504
View this thread: http://www.excelforum.com/showthread.php?threadid=497873
Bob the strings are just text
> please tell us what is in each cell prior to concatenation
> -------------------------------------------------------------...Concatenate A1, B1, and C1 into D1
I have data in Column A1, B1, and C1. I’d like to concatenate all three
cells into one sentence in cell D1. Does anyone have code that can do that?
I'm guessing here that it's not just A1, b1 & C1 you want but if you do why
not this in d1
If it's a column of data then try this
Dim lastrow As Long
Dim C As Range
Set sht = Sheets("Sheet1") 'Change to suit
lastrow = sht.Cells(Cells.Rows.Count, "A").End(xlUp).Row
Set MyRange = sht.Range("A1:A" & lastrow)
For Each C In MyRange
C.Offse...REPLACE RANGE("A1:E20") with variable
I did a macro record building a chart and got this piece
TypeName:="Line - Column"
("prodcpu").Range("A1:E20"), PlotBy _
I can't use this as a permanent macro because the E20
might be E57(different number of entries) next week. The
A1 will always be the start cell.. NEED CODING TO REPLACE
A1:E20 as some variable Thanks.
There are a number of possibilities:
Shee...All cell contents within a range of cells turns white if Sheet1!A1 = 1
If the return of Sheet1!A1 = 1, I need all fill, font and line colors
to turn white from A1:E10. If the value of Sheet1!A1 changes to 0,
all colors must return to normal. Does anyone have any thoughts on
this? Thanks for any suggestions.
If your range to format is on Sheet1.............
Format>CF>Formula is: =$A$1=1 Format to suit
If range to format is on a sheet other than Sheet1
Select Sheet1!A1 and give it a name..............insert>name>define
On other sheet select range A1:E10 and Format>CF
Form...logical (if a1=specific word, can c1 = value entered in a2?)
I am trying to make a payroll sheet so that if someone enters the word "Stat"
into field a1, and then manually enters the number of hours worked into a2,
then c1 automatically displays the same value that a2 displays.
(I have 2 different columns at the end, one for regular hours and one for
stat hours, and I need them to display all of the regular hours into one
field and all of the stat hours into the column beside it.)
> I am trying to make a payroll sheet so that if someone enters the word "...