Prompt Message Query

S

SamuelT

Hi all,

Now, I know that we all hate Excel's paperclip 'helper'; however,
have been asked to create a worksheet that once a cell has been fille
in the l'il bastard pops up and gives a prompt for what the user shoul
do next (e.g. 'Go to Sheet2').

I know that using Validation you can bring up a message when the cel
is selected, and that if you're using a validation drop-down you ca
summon the evil piece of twisted metal to give a message. However,
can't find a way of bringing it up when you've simply completed a cell
Any ideas?

TIA,

SamuelT

PS - If you love the Paperclip, my apologies...and seek psychologica
help. :eek:
PSS - I know you can turn the paperclip off, but I still need a promp
message
 
A

Ardus Petus

Paste following code (after adapting to your needs) to Workbook's code
(right-click on excel icon on top left of your window, then select Code")

HTH
--
AP

'-----------------------------
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Select Case Sh.Name
Case "Sheet1"
Select Case Target.Address(0, 0)
Case "A8"
Range("D12").Activate
MsgBox "Fill SS number"
Case "D12"
Worksheets("Sheet2").Activate
Range("B2").Activate
MsgBox "Fill amount due"
End Select
Case "Sheet2"
Select Case Target.Address(0, 0)
Case "B2"
Range("C13").Activate
MsgBox "Fill Dept. no."
Case "C13"
Range("C4").Activate
MsgBox "Fill D.O.B"
Case "C4"
MsgBox "Done - save workbook"
End Select
End Select
End Sub
'-------------------------------------------
"SamuelT" <[email protected]> a écrit
dans le message de [email protected]...
 
Top