Adding Pop-Up Documentation to a Cell

Thank you, this is exactly what I was looking for and your answer was succinct and clear as day.

one excel file converted to 7-zip but I want to reopen in excel still not opening when i tried.
suggest me.

Great tip. The pop-up has a character limit. How can you add more text/characters/make the pop up box larger?

Anna et al
What is needed is a dependant drop-down. Try this page by Debra Dalgleish at https://www.contextures.com/xlDataVal02.html Lot of different methods.

@Sam
If you want cell C1 to contain the result of cell B1, put this formula in cell C1
=B1

Hi!

I want to copy the result of my formula (output of a formula only and not the formula itself) in Column 2 automatically to column 3. Is there any function or way to do that? PLease advise.

Thanks
Sam

Thanks so much for all of your helpful tips and information. Much appreciated.

Thani you so much for this tutorial. I was getting annoyed by the pop up and didn't know how to remove them. I was getting online tutorials about comments and notes and just found out 'Pop-up" are not the same! Life Changer! Thank you.!

thank you sir...Its just working....

Hello,

Is it possible that the pop-up message is dependent to a certain variable?

I have a spreadsheet that contains numerical data in different currencies. I wanted that when I clicked the cell with a foreign currency data, the pop-up will the show the equivalent into US$, but subject to current exchange rate.

It appears that my content is too large to fit into the pop-up. Is there a way to increase the size of the box or make it scrollable?

thanks for this tip! Is there a way to embed a link or format text at all within this popup?

I want cell to show message ONLY IF date exceed
Like: Sep 10, 2017 pass, ID card have to be changed.

Thank you! Now I can remove this pesky "comment" box from my document I started from a template.

I am writing my own comment, its my own. I did not copy, because I have my own comment with me, all the time. Do you really think someone is going to visit your site and use someone else comment ?
Dude, grow up now !

Thank you for this

This is really useful.

thank you.

YAY!!!
Thank you so much.
I have a rather insane spreadsheet where most of the cells need to get edited frequently to update new information. There are certain cells that CANNOT have their info edited without screwing up a whole lot of other things - however, those columns still need to be sorted as related data gets edited so "protecting" those cells was out of the question. This will prevent me from accidentally screwing up several weeks worth of work (again) because I'll have that lovely popup reminder to "DON'T CHANGE THIS FRIGGIN' DATA!"

I made data validation messages for two different cells. When I select either of these two different cells the data validation message pops up in the exact same location. That's not supposed to happen. Do you know any reason why this could be happening?

It was really helpful.
Thanks

I am working on an excel file created by an organization I work for. After using this file for 8 months, it suddenly has all pop-up text boxes are open and they will not close. I cannot use the file because cells are completely covered. I had this happen earlier and I could right click on the cell with the ? in the circle and then choose "hide" and it would disappear. This is not working. Any ideas for what I can try???

Hi,

Good Morning,

Thanks for help,

Regards
Babu

@Willy

Cheers, Willy.
This will make life a lot easier than putting it in manually.

I have been a little hasty yesterday. The correct code for two columns is:

If Target.Column <> 2 AND Target.Column <> 3 Then Exit Sub

@Scott and Thomas

I am happy you like my code.

For the whole sheet, you can simply remove the first line:
If Target.Column <> 2 Or Target.Cells.Count > 1 Then Exit Sub

For two columns (for example columns 2 and 3), you can replace it by:

If Target.Column <> 2 Or Target.Column <> 3 Then Exit Sub

Since this is an event macro residing in the sheet's code page, it is only fired when you change something in the corresponding worksheet. So if you want this feature in other sheets too, you have to put the macro in each sheet's code page.

Scott
The easiest ways to change the whole sheet is to change the "<>2" to "<1" in the code Willy created. He sure did a great job.

Thanks Willy! I love your code!

@willy

That's awesome mate and I really appreciate it. Is there a way to apply it to multiple columns or to the whole sheet? Even the whole excel document? Haha
Otherwise I'll do the columns individually if I have to :)

@Scott

You can do it by putting the following macro in the worksheet's code page. To get there right click the sheet's tab and select "View Code".

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 2 Or Target.Cells.Count > 1 Then Exit Sub
With Target.Validation
.Delete
.Add Type:=xlValidateInputOnly
.InputMessage = Now
End With
End Sub

This macro assumes you type the grades in column B (2). If you want to use another column, change the "<> 2" in the first line to the appropriate column number (for instance <> 4 for column D).

It adds the date as well as the time. If you only want the date, replace
.InputMessage = Now
by
.InputMessage = Format(Now,"dd/mm/yy")
or whatever format you want.

This trick is amazing. I'm learning more about excel every day!

I'm a teacher and I use excel for my assessment of kids.

I have a question which would be a great addition. When I type a score (i.e. the number '3') into a cell, I want excel to automatically add the current day's date in the pop-up documentation. Can this be done? So instead of typing in the date individually for each cell or even having the pop down calendar, I want excel to do it automatically. If I need a VBA could you give me a hand writing one and inserting it?

Any help would be great,

PS sorry I have excel 2010
Scott

kandeya

What you need is a command button that is on the developer's tab. You can also insert a shape or text box and assign a macro to that.

how do i Create a button with a caption Sort Price and place it outside the area of the table.
then Attach a macro to the button so that the Price is sorted in ascending order each time the button is clicked.

Thank's a lot, Mr.Allen. God bless you...

Thanks for the guidence and it really helped me.

Thanks for the tip sir. I have created a pop-up.

Thanks a lot this is very useful. I created the meeting calendar. In the cell, I put meeting title only. Than, I put Venue, Time, Contact and others info input message.

thank you very helpful hope to learn more tips from you sir.