How can i identify ther user clicked in particular cell

[karthisucc9]

Hi All I am new to excel vba.

In my project i have a 100 rows and 20 columns. I have to identify where the user clicked in "click for a tip"

For eg if the user clicked the clip for a tip in A[1] Column the Message Box should display

the data in F[1] G[1] H[1] I[1] Column.

if ther user clicked the click for a tip in A[2] Column the message box should display the data

in F[2] G[2] H[2] I[2] Column

like that it should go for 100 colums. how can i do it.

HOw can i identify dynamically where the user clicked.

[arlu1201]

Right click on the sheet name and select view code. Then copy this in -

Please Login or Register  to view this content.

[karthisucc9]

Thanks arlu1201

Your coding is working fine. But When i click any column. It display. I want make condition

if row1="Clickforatipe"

Then i have to display the tip

or else i dont want.

how can i identifies the user clicked the "Click for a tip"

Thanks in advance

[arlu1201]

In which cell will the text appear?

[karthisucc9]

Thanks Thanks arlu1201 for your reply

I have column 5 i have Click for a tip options

1 Click for a tip
2 Click for a tip
3 click for atip
4
5
6
7 Click for a tip


When i click in the columns 4 the empty message box is displaying . How to avoid it.