Solved

What is this 'Comment'-like pop-up feature in Excel ?

Posted on 2015-02-10
6
56 Views
Last Modified: 2016-02-10
Hi All,

I've just come across a feature in Excel which I've never seen before. When I click on a cell it displays as a pop-up box with comment-friendly text inside. The pop-up can be dragged around the sheet but I can't find a way of editing the text or deleting it completely. If I click off the box, it hides.

It's not a Comment because I can insert and edit one of those in the same cell as the pop-up.

I've attached a PNG of it.

Thanks
Toco
Excel-comment-like-feature.PNG
0
Comment
Question by:Tocogroup
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40600710
Hi,

This looks like a PopUp Input message created VBA.

When you go on a cell selection, it automatically show the InputBox.

Is this a VBA macro excel file?

ex:
 .InputTitle = "Reporting Period Start Date"
     .InputMessage = "The start date of the reporting..."

Open in new window

0
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40600758
Here is an example i did
input message
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r As Range
Set r = Intersect(Target, Range("C1:C" & Rows.Count))
If Not r Is Nothing Then

With r.Offset(, 0).Validation

 .Add Type:=xlValidateInputOnly
  .InputTitle = "Reporting Period Start Date"
     .InputMessage = "The start date of the reporting..."
     End With

 End If
End Sub

Open in new window

Input-message.xlsm
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 40600759
It could also be the message box from the Data Validation Function.

Thanks
Rob H
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 11

Expert Comment

by:Wilder1626
ID: 40600773
Rob is also correct.
You would have access to it by just following below picture:
Input box
0
 
LVL 33

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 40600789
Thanks WIlder, I was working on screen shots to explain.
0
 

Author Closing Comment

by:Tocogroup
ID: 40600926
Thanks Rob. That's exactly what it was.
Regards
T
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question