On click msgbox [need urgently]

[abdulasad]

1) is there any way that when i click a cell in a sheet then a msg box pops open.
i want to put it in a function/sub

2) how to pass an array from a function to another function or sub


Please i want it urgently...

[arlu1201]

Right click on the sheet and select View Code. Put this code in

Please Login or Register  to view this content.

Explain what you intend to do in your point 2 above.

[smuzoen]

If you want to for example a msgbox to open in Sheet1 when you click cell A1 then in Sheet 1 place the following code

Please Login or Register  to view this content.

Part 2 - pass an array
Probably need a little more information but as a guide

Please Login or Register  to view this content.

The doWork sub populates a 2 dimensional array and passes it to the sub test which prints out in the immediate window the values of the array. Same works with function - just pass the array to the function and the function then does something with the array and returns a value - e.g. add up the values in the array. That is the basics but depending on what you want to do just pass the variable to the function or sub.
Remember the purpose of a function is to return a value so many times you may not need a function - depends if you need to return a value.