Creating an Excel popup

[Sjd0016]

I am looking to have a popup display a value in a specified cell. Thanks in advance!

 

[My Aswer Is This]

Define "Popup"

I know of no such term in excel vba.

And show value from what cell?

Do you mean Message Box?

And how do you want this Vba script to be activated.

You need to provide details when asking question.

 

[Sjd0016]

Message Box with the value from the cell assigned and a simple "ok" to close it

Thanks

 

[My Aswer Is This]

You want a Vba script written that will put the active cell value into a Message Box.
And this script is going to run when you do what?

You have to say what will cause this script to run.

Will you click a button use a shortcut key enter a value into some cell????

You have to tell me what must happen to cause this popup to display.

 

[Sjd0016]

I will like to have it display when the cell value is changed. The cell I wish to display is using a Index function to return my desired value.

 

[My Aswer Is This]

So your saying if any cell value on the entire sheet is changed. You want a message box to popup displaying the value in that cell. Is this correct?

If any value in any cell on the entire sheet is manually change then have a Message Box Popup displaying the value in that cell.

This would mean if any value in all 1.5 million rows and 13,000 columns would be manually changed you want a Message Box to popup showing the value in that cell.

 

[Sjd0016]

If it can only display when the value in the assigned cell is changed but if any cell is changed and it displayed would work fine
.

 

[My Aswer Is This]

You have said now about three times:
"specified cell" and "assigned cel"l.
But you have never said what assigned cell.

What is the assigned cell??????????

If it can only display when the value in the assigned cell is changed but if any cell is changed and it displayed would work fine
.

 

[Sjd0016]

It will be a cell containing a text

 

[My Aswer Is This]

Someone else here at Mr. Excel will have to help you.
I just cannot believe what your asking for.

Your saying if you enter "George" in Range("B1") you want a Message Box to popup with "George"
If you enter "Sam" in Range ("G34") you want a Message Box to popup which says "Sam"

I cannot believe anyone would want this.

Why would you want something like this.