Automatically display comment box

JKD

New Member
Joined
Sep 6, 2006
Messages
2
Please forgive me if this seems like a dumb question, as I am a comlete novice to Excel. I tried to use the search function, but was unsuccessful in finding my answer.

I have run across an Excel spreadsheet, whereby if you selected certain cells, a comment box would automatically pop up with some information. This was a form that I was filling out, and the comment boxes were basically instructions on what to put in particular cells. These comments were not inserted, as there was on little red triangle in the upper right corner of the cell. They just automatically appeared when the cell was selected.

I am trying to do the same but can't figure out how this was done. I'm guessing it is some sort of macro, but I can't seem to find what I'm looking for. Any help would be greatly appreciated.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
Check this.

Data....Validation....Click on the Input Message Tab...Enter your message.

HTH
Cal
 

JKD

New Member
Joined
Sep 6, 2006
Messages
2
Thanks! Sheesh, I'm such a noob! :rolleyes: Sorry to bother you with something so simple! :LOL:
 

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
No worries, lots of people are unaware of the validation features. It's great using the list option, which gives you a drop down right in the cell.

Welcome to the board.
 

Forum statistics

Threads
1,137,298
Messages
5,680,689
Members
419,927
Latest member
Axtros

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top