Recent content by mavest

Thanks! I'll check out your method tomorrow. Today, I'm a bit tight on time. For the record I did find another solution, although not as elegant. The solution I found was to use a function on the worksheet to store the position of the cell whose value was changed. The position is stored in...

Combo, Not sure how our timer and collection system is to work. The problem I'm faced with is that I cannot change the worksheet while in a worksheet function. If I could get out of the function and then raise the event, I'd be perfect. -Mike

Thanks for your help! Your technique will be quite useful.

Very interesting! I tested it and it works! Thanks! I might not have a full understanding of your intentions, but I took the range of interest and used it as the input parameter to the function Changer. I hide this function call somewhere on the worksheet. Since Excel will call the function...

Not sure what you mean, or if it applies to my situation. Explanation: The range of interest contains only Excel formulas. So, the values of the cells in the range of interest are changed by Excel logic in a large multiple worksheet workbook. Since the cells in the range of interest are not...

Anyone know the best method to filter the Worksheet_Calculate event such that code is executed only when the cell values of a certain range have changed, i.e. been re-calculated? I noticed that no Target range is passed to this event function; so, I cannot find the range by the same method...

Great! Thanks Skip! I was hoping that there was an enable events toggle out there!! Other Solution: In the past I've used the counter/boolean idea, by declaring a global and changing its value inside the event. But this solution is messy and if not properly implemented can lead to uncertain...

How best can I escape an endless (infinte) series of worksheet_change events? Is there and FAQ, or does anyone have any suggestions? Thanks! Details: I am using the worksheet change event to trigger a calculation when a user types in a value in a certain cell. However, as the last step of...

In VBA my function looks as below. The Tower_1_Data and Tower_2_Data are ranges of data in the worksheet. When data in these ranges change, it causes Excel to call the function. The function then calls the dll, which I don't always want to happen because it takes a long time. So, I'd just...

I have a series of cells that contain calls to a VBA function. This function in turn calls a dll. There are times when I do not want this function to call the dll, but to just want the function to return the present value in the cell. Using the debugger, I've noticed that by the time the...

What is the preferred way to anchor an Excel Chart to a named range or other position in a worksheet. I've got some code that generates a chart and locates it on the worksheet. But some time later when I've added more rows above where the chart is generated, the next time I generate the chart...

For the forum records, I found a solution to the problem, but did not yet find THE solution/reason. Symptom was that I was getting the above discussed error anytime I tried to insert a standard control object from Excel, such as ComboBox, Command Button, ... I only had this problem for this...

Thanks all but I've tried both and no solution. > tried Help/Detect and Repair > tried Tools/Options/View/Objects - show all was selected. I did a google search and found at the MS help that this error can occur when someone creates a custom control from say C++ and has a different version in...

I've got an Excel workbook that does some complicated calculations involving VBA and has alot of named ranges, VBA code, and Control objects such as command buttons, comboboxes, etc. All of a sudden none of the worksheets will allow me to insert a ComboBox or any other control. This is greatly...

Thanks for your try, but coding is not involved. The problem is when I manually try and insert an object like a ComboBox or Command Button onto a worksheet. I've checked if the workbook or sheet was protected and no - they are unprotected. This problem does not involve any coding, but...