Change function from on button click to when value entered

fI seem to always have to start these with I don't know anything about coding so please bare with me.

I have some code that does a funtion on a button click that looks like below

Please Login or Register  to view this content.

However, I would rather the function above be achieved when text is entered. I have the following code that functions this way but does something different. I tried to see if I can have the action do what it does above but without a button click.

Please Login or Register  to view this content.

I have a mess on my hands. My new code looks like below but it keeps throwing an error on the If Worksheet.Function line.

Please Login or Register  to view this content.

If you need me to upload the file, I can do that. I give big thanks ahead of time to anyone willing to help this poor slob.

Hi rmc,

I think you need to learn about VBA Events. Then you need to see how they are triggered. I think you are looking for a worksheet On_Charnge event to trigger your code. Read these:
http://www.tutorialspoint.com/vba/vba_events.htm and
http://www.cpearson.com/excel/Events.aspx

It seems to me you have learned that a button click can trigger some code but haven't yet found worksheet events.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here