Cell Change

  • Thread starter Thread starter timO
  • Start date Start date
T

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
 
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
 
Back
Top