pop up box is needed to display the data in the cell for all the rows dynamically

[Deepthik]

Hello all,
I am sorry for not following the forum rules in my last thread, i have a query in T column in the attached excel sheet.

My problem is :
----------------------------

I need the data present in the T column cells to be displayed in a pop up box dynamically.

Note : " pop up " in the sense that a small description box which appears beside the cell

Description of my excel sheet :

Here the rows start from the row number 43 and column B .
Can anyone please help me with the code for displaying the data in pop up box for all the row dynamically .that is the data present in the T column cells should be presented in a pop up . If there is no data in the cell,then there should not be any pop up

The code logic code loop should stop wherever the data ends in the sheet

[teylyn]

deepthik,

why don't you return to your previous threads and and react to / acknowledge the comments there before you embark on a new venture.

In general, our members would like to learn from the poster if the suggestions provided were useful, or if anything is still missing. Also, there seem to be some outstanding actions requested from you. If you don't respond to replies to your threads, don't expect any more answers to your questions.

cheers

[Deepthik]

hello i ve thanked in the prevoios thread..nw i hope i can get answer 4 my question

[JBeaucaire]

These "popups" as you call them, they are comment boxes, correct? Comments are the boxes that appear when you hover your mouse over a particular cell.

So, you want the text in column T added to "comment boxes" elsewhere on the same row?

The T43 value is "T06"....which cells in row 43 would receive this comments box? B43?

How do you want this macro activated? You'll do it manually? Or do you want the comments added immediately anytime you enter a new value into column T?

[Deepthik]

hey i want the comment boxes only in T column.whenever the user clicks in any cell in T column then it should display that particular data in a comment box.

the data starts from B43 and comment box is needed only for the data in T column.

no i dont want it to be done manaually.I want a macro such that whenever the user clicks in any cell in T column then it should display that particular data in a comment box.

can you please help with my problem with a help of a macro.

[JBeaucaire]

Now I'm really confused. You want to click on T43 and have a popup comment box appear showing you the content of cell T43 as the text in the comment box? Why? You can already see the content in T43 as you click the cell. What's the point here?

[Deepthik]

yes it can be seen but i want the T column data in a COMMENT BOX.
It should be done for all the rows in T column till the data is present.

[Deepthik]

yes it can be seen but i want the T column data in a COMMENT BOX.
It should be done for all the rows in T column till the data is present.

I WANT A COMMENT BOX FOR EACH CELL IN T COLUMN TO BE APPEARED IN A COMMENT BOX.
HERE THE DATA STARTS FROM B43.
THIS SHOULD BE DONE WITH A HELP OF A MACRO.

[JBeaucaire]

This will do what you've said...it will insert the text into a comment box each time you double-click a cell in column T. This macro goes into the SHEET module:

Please Login or Register  to view this content.

If you want to add comments to all the cells in column T all at once, or delete them, use these macros...place these into a regular code module:

Please Login or Register  to view this content.

[mikerickson]

In your attachment what do you want the comment box for T43 to show?
Do you want a string listing all of the data from that row, like:
"NST
3
46318
101-30-62-02
30-DEC-2004
13:01:22


111,287.00
111,287.00
CLECKTYEG
Approver
1
12/30/04
1/31/05

1
T06"

or some other string?

What do you want the comment for T44 to be?

[teylyn]

Deepthik,

please stop quoting whole posts. It's just clutter.

Also, as I've asked you before, don't use ALL CAPS text as it is considered not polite. You come across as very demanding, whether this is your intention or not. This kind of attitude is not something many helpers here put up with.

[Deepthik]

i am sorry.actually i thought only title shouldnt be in caps.i wont repeat it again.
i am aware of it nw.

[Deepthik]

@ JBeaucaire:

hey actually what is main difference in two macros you had mentioned.i mean can you please redefine what the first and the second one does again.i didnt not understand it that clearly.thank you.

[Deepthik]

i have another doubt here.what does option explicit do???can you please explain the code too in brief.thank you.

[Deepthik]

@mikerickson

i just want data for the T column data to be displayed in a pop up box when the user clicks an any cell in that column.
that is in row 43 and under column B the pop up box should display T06 then again for
b44 it should display T06
then again for T45 it should be T06
than for T46 it should display T03 likewise for all.
it should display whatever data appears for each cell in whole column.
and if there is a blank( that is no data)than it should not display anything in the popup box(description box).

[Deepthik]

can i have a pop up box instead of a description box.i mean the pop up box which we get when u go to data validation-->input message-->title and message one.

can i have a real pop up box for each cell on T column instead of a description box.i mean it will look more realistic.

thank you.

[teylyn]

Deepthik,

one more reminder: don't quote whole posts, please. In fact, only quote if you're not replying to the previous post, and if you quote, then only the relevant parts of a post, not the whole thing.

[Deepthik]

alright...wont quote again and again