CREATE A MACRO TO SHOW A POPUP IN EXCEL 2007

Question

HI I'M WORKING ON VSTO 3.0 WITH EXCEL 2007... HERE IN EXCEL PROJECT ..I'M USING LISTOBJECT(LIST1) WHERE USING DATASOURCE I 'M RETRIEVING SQL DATASOURCE TABLE... WHAT I NEED IS HERE LIST1 DISPLAYS TABLE FIELDS....WHEN I CLICK ON ANY CELL OF EXCEL IT SHOULD DISPLAY WHOLE ROWS CONTENTS INTO POPUP ....

rakesh aytha · Answer

Is there any way to write the code for popup in sheet1.cs without using macros...

rakesh aytha · Answer

thank You.. can u explain me how to use the macro created.... i'm able to create a macro but i dont know how to access it

Javeed M Shaikh · Answer

can you use msgbox  try this... Dim myrng As Range Set myrng = Range(C1) MsgBox Cell  & rng.Address ' I am not sure if Address is the correct property please check. Set myrng = Nothing