About Us

Brad

That did it - thank you very much.

"Art" wrote:

Brad,

Instead of: Dim SW As String
Use: Static SW As String

"Brad" wrote:

You answered my question - but it leads me to another question.

There must be a way to have the Macro remember the variable.

"Dana DeLouis" wrote:

The macro - works correctly the first time - but ...

If I am not mistaken, each time the code runs, SW is initialized to ""

Dim SW As String

When you set it later in your code...

SW = "used"

it is not remembered between calls.

--
HTH :)
Dana DeLouis
Windows XP & Office 2007

"Brad" wrote in message
...
The intent of the macro was to force information into cell(s) once, but
allow
the user to change the information if they had better numbers.

The macro - works correctly the first time - but it overrides any changes
entered by the user.

Sub Worksheet_Change(ByVal Target As Range)
Dim lookrng1 As Range
Dim lookrng2 As Range
Dim lookrng3 As Range
Dim lookrng4 As Range
Dim lookrng5 As Range
Dim key2 As String
Dim SW As String
Application.EnableEvents = True

If Left(Range("Prod1").Value, 3) = "LBD" Then
SW = "off"
ElseIf Left(Range("Prod1").Value, 3) < "LBD" And SW < "used" Then
SW = "on"
End If

If SW = "on" Then
Range("d17").Value = Range("c9").Value
Range("d19").Value = Range("c9").Value
SW = "used"
End If

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vb macro format is wrong	what which is up	New Users to Excel	5	February 23rd 10 10:25 PM
What is wrong with this Macro?	jeannie v	Excel Worksheet Functions	16	February 24th 08 05:05 PM
What's wrong with this macro?	belly0fdesire[_2_]	Excel Programming	5	January 26th 06 11:00 PM
What have I done wrong with this Macro???	Shandy720[_5_]	Excel Programming	1	August 12th 05 04:45 PM
What have I got wrong? (Macro),,,	ste mac	Excel Programming	2	November 7th 03 11:07 AM

Menu

About Us