Home » Forums » Open Source Learning Center » Question and Answer

VBA Help needed Fast

Submitted by dragonv29 on 15 June, 2014 - 14:24

(How do you get the user to select cell A1?) IF he/she does not select A1, there should be a msgbox appearing to tell them to select A1. What is the vba code for this?

‹ Question on Excel Is this a possiblity? ›
»

Workbook_SheetSelectionChange

Submitted by Tor Carl Eimstad on 26 June, 2014 - 10:09.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address <> "$A$1" Then
MsgBox "Please select cell A1"
End If

End Sub

»