VBA - Hello, I would like to do the following. If cell A1 contains "Hello" and if the focus is on A1 and i

GeekInterview.com > Interview Questions > Programming > VBA

Go To First | Previous Question | Next Question

VBA | Question 51 of 60

Hello, I would like to do the following. If cell A1 contains "Hello" and if the focus is on A1 and if the Enter key is pressed, then the focus should go to B2 and a MsgBox should appear. I think this can be done with key events, something like OnKeyDown, but how do I tell it I want the event only be triggered by the Enter key?

Thanks, Liglin

Total Answers and Comments: 2

Last Update: June 08, 2007 Asked by: Liglin

Concepts of Object-Oriented Programming

Object Oriented JavaScript In this chapter you ll learn about OOP Object Oriented Programming and how it relates to JavaScript As an ASP NET developer you probably have some experience working with objects and you may even be familiar with concepts such as inheritance However unless you re already a

SQL Programming

SQL Programming Overview Anybody who has done something for a long time has probably wanted to change how things work at some point or another. A worker at a mill might have found a more efficient way of cutting logs, or a mathematics teacher might have had a hand in changing a school’s al

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof

WinRunner Programming Concepts

If you want to create WinRunner scripts that are highly efficient, there are important programming concepts that you will want to become familiar with. Understanding these concepts will provide you with a large number of key benefits. In addition to understanding these concepts, you must also learn

Programming Languages Certification

IT Certification programs have several options that will offer you the best knowledge.  By learning everything that you need to know about information technology you will be able to open new doors to your career and personal business desires.  IT Certification offers several vari

JavaScript OnError Event

JavaScript OnError Event In this JavaScript tutorial you will learn about onerror event how to use onerror event along with syntax and example mosgoogle center Using onerror event The onerror event fires when a page has a script error This onerror event occurs in JavaScript when an image or document

JavaScript Event Handler

JavaScript Event Handler In this JavaScript tutorial you will learn about using event handlers along with events for each HTML tag mosgoogle center Using Event Handler in JavaScript Event Handlers are used in JavaScript by placing the name of the event handler inside the HTML tag associated with obj

SOA 2.0 Event Driven Architecture

SOA 2 0 Event Driven Architecture There has been much negative press in recent years in regards to Oracle’ s touting of SOA 2 0 as the next generation version of SOA Its combination of Event Driven Architecture with SOA considers the first iteration of SOA to be a mere client server drive

Neuro-linguistic Programming Methods

Neuro linguistic Programming Methods There are several methods used for performing Neuro linguistic Programming on an individual for obtaining insights into the psyche of the person in order to correct to modify certain patterns of behavior These techniques are also used for Neuro linguistic trainin