Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mavest

  1. mavest

    Worksheet_Calculate - How Best To Filter Event For A Single Range

    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...
  2. mavest

    Worksheet_Calculate - How Best To Filter Event For A Single Range

    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
  3. mavest

    Worksheet_Calculate - How Best To Filter Event For A Single Range

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

    Worksheet_Calculate - How Best To Filter Event For A Single Range

    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...
  5. mavest

    Worksheet_Calculate - How Best To Filter Event For A Single Range

    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...
  6. mavest

    Worksheet_Calculate - How Best To Filter Event For A Single Range

    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...
  7. mavest

    Worksheet_Change Event

    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...
  8. mavest

    Worksheet_Change Event

    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...
  9. mavest

    Returning Existing Cell Value From A Function Call

    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...
  10. mavest

    Returning Existing Cell Value From A Function Call

    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...
  11. mavest

    Excel Chart Location

    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...
  12. mavest

    Excel Error - Cannot Insert Object (ComboBox)

    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...
  13. mavest

    Excel Error - Cannot Insert Object (ComboBox)

    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...
  14. mavest

    Excel Error - Cannot Insert Object (ComboBox)

    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...
  15. mavest

    Excel - Cannot Insert Object (ComboBox)

    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...
See more

Part and Inventory Search

Back
Top