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.
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.