GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Programming  >  VBA
Go To First  |  Previous Question  |  Next Question 
 VBA  |  Question 51 of 60    Print  
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 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 16, 2006 06:36:14   #1  
samitbasu Member Since: February 2006   Contribution: 1    

RE: Hello, I would like to do the following. If cell A...
Use KeyAscii and trap enter(32).
 
Is this answer useful? Yes | No
June 08, 2007 08:26:26   #2  
sc        

RE: Hello, I would like to do the following. If cell A...
Trap Enter with ASC code 13 not 32 (which is ASCII code of space)
 
Is this answer useful? Yes | No

 Related Questions

Latest Answer :  Shape and Line Controls ...
Read Answers (3) | Asked by : Beena

Latest Answer : MsgBox is a built in VB function which displays a Message Box and MsgBoxQ is a function defined by the user. ...
Read Answers (1) | Asked by : Beena

View Question | Asked by : Beena

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
Read Answers (2) | Asked by : Liglin

1) You are creating a client application that calls ActiveX DLLs. Which of the following properties of the Err object provides the name of a component that sends an error back to the client application? a. Number b. Description c. CompName d. Component e. Source f. Text g. Desc h. None of the above2) If the Cancel Error Property of the CommonDialog Box is set to true then which of the following statement is true: a. A runtime error can result if the user clicks the cancel button b. A
please give me the answer for this . who is the master. 
Read Answers (1) | Asked by : shailesh


 Sponsored Links

 
Related Articles

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
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape