Anyone have any ideas, I am trying to close out my project today, and am
just stuck:-(
Norman,
This is great!! I am really learning a lot and it is perfect for my
project. Can I ask another question, because I think you will be able
to answer it without thinking:-)
I have four rows of input for each entry (typically there are 50-100
entries per FCST):
1. Potential Sales
2. Sales FCST
3. Shipping FCST
4. Original Booked
I would like a message box to appear (similar to the one in the earlier
code) that says you "Can't change Original Booked". This is because this
field is pre-populated and is for reference.
I would imagine the statement to be:
If range(same row, column B) = "Original Booked" Then
res = MsgBox( _
Prompt:="You can't change Original Booked" & _
"to change the value of " & _
"Cell " & rng.Address(0, 0) & "?", _
Buttons:=vbCancel)
If res = Cancel Then
..Formula = oldVal
End If
End With
Any ideas??
Thanks,
Matt
--
matt4003
------------------------------------------------------------------------
matt4003's Profile:
http://www.excelforum.com/member.php...fo&userid=9635
View this thread:
http://www.excelforum.com/showthread...hreadid=508707