Prompting users with a message box on certain cells
thanx, this worked
BUT, I need a total of 31 lines/sentences to complete my message
the last 7 lines are on the same line as the 7 previous lines
how do I extend the message box
--
thanx
"Gord Dibben" wrote:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Const sINPUTS As String = "B18,B24,B37"
If Not Intersect(Target, Me.Range(sINPUTS)) Is Nothing Then
MsgBox "your message"
End If
End Sub
Right-click on the sheet tab and "View Code". Copy/paste into that module.
Alt + q to return to the Excel window.
Gord Dibben MS Excel MVP
On Thu, 29 Jan 2009 16:49:01 -0800, tommy
.(donotspam) wrote:
Sorry,
but I dont want to use Insert Comment or Data Validation
I want the message box to pop up since it forces the user to read and click OK
|