How cal i populate the Dialog Box when the Right Click mouse Button

**karthisucc9** · 02-21-2012, 03:09 AM

Hi All

I am new to excel Vba .In My project When i right click in the sheet the Dialog Box Should display.

How can i do it

Thanks in advance

**royUK** · 02-21-2012, 03:15 AM

Which dialog box? The sheet module has before right click event

Please Login or Register  to view this content.

Workbook Event code should be added to the workbook code module:

Copy the Excel VBA code that you want to use
Select the workbook in which you want to store the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste

**karthisucc9** · 04-04-2012, 08:13 AM

Thanks Roy UK your coding is working fine and good.

but i have one problem i have 10 sheets.

When i click the right button in any 10 sheets

the user form should appear.

It only works in single sheet.

How can i do it.

Thanks in advance.

**royUK** · 04-04-2012, 08:19 AM

Please Login or Register  to view this content.

Workbook Event code should be added to the workbook code module:

Copy the Excel VBA code that you want to use
Select the workbook in which you want to store the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste