need help with If statments or VB if possible

Microsoft Office Forums

		Microsoft Office Forums > Microsoft Excel > Excel Programming
need help with If statments or VB if possible

Reply

#1

Old

05-02-2012, 11:01 AM

jerryj

jerryj is offline

need help with If statments or VB if possible

Windows XP need help with If statments or VB if possible

need help with If statments or VB if possible

Office 2010 32bit

Novice

need help with If statments or VB if possible

Join Date: May 2012

Posts: 1

jerryj is on a distinguished road

Thumbs up

need help with If statments or VB if possible

What im trying to do is, if sheet2!A1:A5 is updated then id like to put a "*" on sheet1!A1:A5

Reply With Quote

#2

Old

05-04-2012, 08:24 AM

Peter Wienand Peter Wienand is offline

Peter Wienand is offline

need help with If statments or VB if possible

Windows 7 64bit need help with If statments or VB if possible

need help with If statments or VB if possible

Office 2010 32bit

Novice

Join Date: May 2012

Posts: 15

Peter Wienand is on a distinguished road

Default

You could try something like this in the Sheet2's worksheet change event

Code:

 
Private Sub Worksheet_Change(ByVal Target As Range)   Dim c As Range
 
    For Each c In Target.Cells
        Sheets("Sheet1").Cells(c.Row, c.Column).Value = "*"
    Next c
End Sub

Reply With Quote

Reply

Tags

new text on cell, put * on another sheet, updated cell

« Previous Thread | Next Thread »

Other Forums: Access Forums

All times are GMT -7. The time now is 05:53 AM.