worksheet change event

Hi there. I've used a macro from within these here walls so that a user can open a template worksheet ("sheet2" for example), click on a button, and it asks what they would like to call the new sheet, and as if by magic (or vba), a new sheet is created based on the template with the name...

Hi - I'm somewhat new to VBA and I'm having trouble with Worksheet_SelectionChange event. I've got a Forecasting spreadsheet that has about 20 worksheets (1 'Input Sheet' and 19 other worksheets - 1 sheet for each of our 19 products). On the 'Input Sheet', I have a Data Validation drop down list...

I am wondering if it is possible to have a worksheet change event trigger a macro in excel. What I have is an invoice tab that feeds several different revenue tabs, depending on what type of revenue. What I am wanting is a worksheet change event that will trigger a macro when something in the...

Hi all, This code works for me but it has a bad side effect. If I attempt to highlight data and "CLEAR CONTENTS", it inserts zeros in the cleared cells. It does the same if I run a macro that clears the entire work range. Any ideas on how I might fix this? Also, is it possible to run a...

I have a shift schedule setup. Each half hour is marked by a single character, either an l or t. I am trying to use VBA to change the cell pattern/colors. If a user inputs more than one character the code will change the cell formatting. I would also like for it to prompt the user that they...

I have an input sheet, where column A has a dropdown list. Column B has a dropdown list that is dependent on the value selected in column A, using the INDIRECT function. One of the problems is that if the user then changes the entry in column A, I need to clear the entry in column B so that the...

Hello, I have a worksheet that I frequently paste data into so that it can be used by another sheet in the workbook. I've inserted a procedure to change numbers stored as text into values into the worksheet object, and it works perfectly when I paste the data into the sheet. However, if I...

How do you run a macro automatically when you change a cell? For instance, i have a macro that does an autofilter called Filtermacro and a cell E2 on worksheet sheet1 that is a drop down box of 200 items. I want the macro to run when i change it from the item on that dropdown. Any help? I...

Hi, I need to resolve a pressing issue that I have at work. Here is my dilemma. Background Info: Currently, I have 15 users who submit data to me on Excel 2003 spreadsheets that I in turn manipulate to report elsewhere (to upper mgt, the government, etc…). In the short term, I need...

Dear all, I have a problem with the Worksheet_Change Event. The below code (attached to the sheet) calls a macro wich does some calculation. This works fine so far. But the macro in the end shell alter some cells in the actual sheet then. If it does so, the Change Event is called again and...