Formula In Excel To Prompt User To Input Date

charlesdh · #3 08-31-2014, 11:53 AM

Hi,

Here's a bit of code that will fire if cell A16 is changed.

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
   'Do nothing if more than one cell is changed or content deleted
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
    If Target.Address = "$A$16" Then

        Application.EnableEvents = False
''''''''''''''''Your code ''''''

        Application.EnableEvents = True
    End If

End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and Prompt the user to Replace	Lawmuse	Word VBA	9	02-27-2023 06:36 AM
User input to a variable on the document	dsm1995gst	Word VBA	1	09-03-2013 03:43 PM
Replacing text with user input.?.?.?	brad1977	Word	3	11-20-2012 10:20 AM
Look up an array based on user input	johnsmb	Excel	2	01-07-2011 01:12 PM
User Name Prompt Appears When Opening Documents	galleherjazz	Office	0	07-30-2009 08:15 PM