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
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
Which dialog box? The sheet module has before right click event
Workbook Event code should be added to the workbook code module:Please Login or Register to view this content.
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
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
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.
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
Thanks royuk
Its worsk fine and good.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks