Sorry, slight typo, should be

Public RunBefore as Boolean

Sub as_sass_Proc()
Dim check

If Not RunBefore Then
check = 12345
RunBefore = True
Else
check = 98765
EndIf

ans = InputBox("Supply Value")

If ans = check Then
'etc.


End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bob Phillips" wrote in message
...
This is the sort of thing I mean

Public RunBefore as Boolean

Sub as_sass_Proc()
Dim check

If Not RunBefore Then
check = 12345
RunBefore = False
Else
check = 98765
EndIf

ans = InputBox("Supply Value")

If ans = check Then
'etc.


End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"as_sass " wrote in message
...
Bob,

sounds good, if I only knew how that worked... Basically what I need is
some variable in my macro that is set to a specific value, but that
value changes to something new once the macro is executed.

As I'm new with this, I'll rephrase it to improve the chance that sb
understands me:

Let's say I'm setting
check = 12345
And then have an InputBox where the user inputs a 5 digit code.
Then the input is compared with "check" (If..Then).
Afterwards, "check" should be set to a new, predetermined value.

It may well be that what you wrote is exactly it, only I really don't
know what you mean...

Thank you so much for your help!

as


---
Message posted from http://www.ExcelForum.com/