close
I have recorded a Macro that runs correctly, but need it to run from an If
function after user has entered a particular word. Any help were be
appreciated.
Thanks Rosey
right click sheet tabgt;view codegt;insert this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address lt;gt; quot;$B$2quot; Then Exit Sub
If UCase(Target) = quot;JOEquot; Then Call bill
End Sub
Sub bill()
MsgBox quot;Hi there Joequot;
End Sub
--
Don Guillett
SalesAid Software
quot;Roseyquot; gt; wrote in message
news
gt;I have recorded a Macro that runs correctly, but need it to run from an If
gt; function after user has entered a particular word. Any help were be
gt; appreciated.
gt; Thanks Rosey
全站熱搜
留言列表
