Cell Change

[timO]

Hello All,
I would like a macro I wrote (text-to-columns) to run
after I input data into a particular cell.

Is there a way to set up my sheet to perform the
operation after I input the data.

Also is there a way to defeat the message box that
asks "Do you want to replace teh contents of the
destination cells?"

Thanks in advance

 

[Tom Ogilvy]

Use the Worksheet_Change event and test for that particular cell

Right click on the sheet tab, select view code. Put in code like this:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If target.count > 1 then exit sub
if Target.Address = "$B$1" then
' call your sub
End if
End Sub