GeekInterview.com
Series: Subject: Topic:
Question: 8 of 60

Need VBA Coding

Within excel, what is the VBA coding to determine if the active cell has a comment assigned to it?
Asked by: Interview Candidate | Asked on: Oct 13th, 2011
Showing Answers 1 - 1 of 1 Answers
Mark Haynes

Answered On : May 1st, 2012

View all questions by Mark Haynes   View all answers by Mark Haynes

Test: ActiveCell.Comment.Text

If ActiveCell.Comment.Text = "" Then
No Comment

If Not ActiveCell.Comment.Text = "" Then
Active Cell has a Comment

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Analytical

Aptitude

Career Goals

Creativity

Critical Reasoning

Decisiveness

Flexibility

Group Discussions

Human Resources

Interests

Job Performance

Leadership

Motivation

Personal Interview

Placements

Puzzles

Quantitative Aptitude

Self Assessment

Skills

Verbal

Warm-Up

Work History

Interview Coaching

What are my options when I do not get a job after graduation?

What are the career options available in Software Testing Industry?

What do you think about our company?

Careers and Higher Education Options for BBA Graduates

What are the things you wish to achieve in 5 years?

How do you handle difficult situations?

How to Overcome Employment Gap during interview.

Describe a time when you had to work under pressure.

Career Options for BCA Graduates

What are the career opportunities available for MCA Graduates?

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe