Perform function when t-character is entered in Column-A

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Perform function when t-character is entered in Column-A

FAQ

Thread Tools

Display Modes

12-14-2017, 02:06 PM

SerenityNetworks SerenityNetworks is offline

Windows 10 Perform function when t-character is entered in Column-A

Office 2016

Advanced Beginner

Join Date: May 2005

Location: Allen, Texas, USA

Posts: 37

Perform function when t-character is entered in Column-A

I'd like to call a sub when the lowercase t is entered in any cell in Column-A. If I were to try and type "Bottom" in cell A2, as soon as the third character (the "t") was typed then a sub would be called where I could perform other operations. If in cell B2 (or any cell not in Column-A) I would be allowed to type "Bottom" without any actions being called.

How can I accomplish this?

Thank you in advance,
Andrew

Tags

vba

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Detecting that previous character doesn't exist (i.e., present character is first in document)	Robert K S	Word VBA	15	08-01-2016 09:33 AM
Formula/function to return column names for matching values	GiJoe81	Excel	1	06-27-2015 12:13 AM
a function that deletes all rows with no value in a certain column?	dunndealpr	Excel	2	06-08-2013 06:50 AM
Perform a search for alternative words	jungkim	Word	2	03-24-2012 07:40 AM
Perform Calculations using List boxes	Jennifer_Falcon	Word VBA	6	07-26-2011 10:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 AM.