wyte32
02-10-2015, 08:48 AM
Hello All,
I have an excel workbook with 2 sheets.
Sheet 1: contains a button for creating a new sheet with user data
Sheet 2: contains data for a company and departments (department heads, contact information, etc...)
On Sheet 2, I have worksheet_SelectionChange code that works. Basically if the user clicks on a cell in columns A or F: comments will appear with more detailed information about that cell. If any other column is clicked, nothing happens.
What I am hoping: I want to place the same worksheet_SelectionChange code (with some modification) from Sheet2 in a module. Is there anyway, that when the button on Sheet 1 is clicked and a new sheet is created, I can apply the module code to the worksheet_SelectionChange for that new sheet?
I have an excel workbook with 2 sheets.
Sheet 1: contains a button for creating a new sheet with user data
Sheet 2: contains data for a company and departments (department heads, contact information, etc...)
On Sheet 2, I have worksheet_SelectionChange code that works. Basically if the user clicks on a cell in columns A or F: comments will appear with more detailed information about that cell. If any other column is clicked, nothing happens.
What I am hoping: I want to place the same worksheet_SelectionChange code (with some modification) from Sheet2 in a module. Is there anyway, that when the button on Sheet 1 is clicked and a new sheet is created, I can apply the module code to the worksheet_SelectionChange for that new sheet?