You might have been used to using an existing worksheet of the workbook you regularly work on as a data-entry format, say, maybe like a Cash / Bank Payment Voucher Entry Sheet.
Obviously, the right click event can only be controlled using VBA, the sheet_rightclick event controls that. You need to set the cancel variable to true and then use code to show the userform instead.
Currently, I am working on a worksheet that contains the assessee information, as shown below.
And here is the userform that will show when I right-click the worksheet.
As you can see, it captures all the information needed to store the information about any assessee. At the moment it is a work in progress and woulod be combined with another worksheet, say, the Income-Tax Return worksheet, to prepare the income-tax return of the assessee.
Cheers !!
CA Vikram Shankar Mathur
23-April-2022 : 09:12 Hours IST
You must be logged in to post a comment.