Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-14-2017, 02:06 PM
SerenityNetworks SerenityNetworks is offline Perform function when t-character is entered in Column-A Windows 10 Perform function when t-character is entered in Column-A Office 2016
Advanced Beginner
Perform function when t-character is entered in Column-A
 
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
SerenityNetworks
Question 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
Reply With Quote
  #2  
Old 12-15-2017, 12:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Perform function when t-character is entered in Column-A Windows 7 64bit Perform function when t-character is entered in Column-A Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Can you please show the macro you already created, some data and what went wrong?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 12-22-2017, 08:15 AM
SerenityNetworks SerenityNetworks is offline Perform function when t-character is entered in Column-A Windows 10 Perform function when t-character is entered in Column-A Office 2016
Advanced Beginner
Perform function when t-character is entered in Column-A
 
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
SerenityNetworks
Default

My apologies. I figured out the solution and totally forgot about responding here.

Again, my apologies.
Andrew
Reply With Quote
  #4  
Old 12-22-2017, 09:24 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Perform function when t-character is entered in Column-A Windows 7 64bit Perform function when t-character is entered in Column-A Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Np
If you have a moment why not share your solution with the board?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
vba



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 function when t-character is entered in Column-A Perform a search for alternative words jungkim Word 2 03-24-2012 07:40 AM
Perform function when t-character is entered in Column-A 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 09:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft