Auto populate cell based on certain situations

NBVC · #1 05-17-2017, 05:30 AM

Hi,

You will need to include an event macro to accomplish that.

Try right-clicking on the tab of your sheet and select "View Code"

Paste this code in the editor.

Code:

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Application.Intersect(Target, Range("A1")) Is Nothing Then
    If Range("A1").Value = "No" Then
        Range("A2").Value = 0
    Else
        Range("A2").Value = ""
    End If
End If

End Sub

Now go back to the sheet and test.

YW3 · #2 05-17-2017, 06:08 PM

Thank you! It worked!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel to auto populate dates based on start and end	patidallas22	Excel Programming	9	04-21-2014 03:14 PM
trying to use vlookup to calculate several different situations in one cell	heastlund	Excel	3	11-21-2013 12:38 PM
auto cell populate 2	Stevejd58	Excel	3	08-20-2013 04:23 PM
auto cell populate	Stevejd58	Excel	14	05-13-2013 02:22 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM