Loading

CREATE A MACRO TO SHOW A POPUP IN EXCEL 2007

rakesh aytha

15y3.3k.NET

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....

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

rakesh aytha15y ago
Is there any way to write the code for popup in sheet1.cs without using macros...
rakesh aytha15y ago
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 Shaikh15y ago
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