event procedure

  1. SharmaAntriksh

    VBA Code to allow refrain certain users from printing the file

    I am using the bellow event procedure of VBA and i want to restrict certain users from printing this file excluding me. For eg - David, Carly and Rachel are not allowed to print the file but Jim, Antriksh, Grant and Rohit can print the file Private Sub Workbook_BeforePrint(Cancel As Boolean)...
  2. K

    Stop Pivottable Changes From Starting Lengthy Workbook Calculations

    Disclaimer: I have a workbook with protected health information in it (reason why workbook is not attached). Also, I have little experience with workbook and worksheet events. Problem: I have a customer complaining that every time they manipulate a pivottable in the workbook, that the...
  3. Z

    Stamp Date Modified After Record in Form is Modified

    I am using Access 2013 and have tried everything to get this to work. I just want a record to be stamped with a modified date after any part of the record is changed. I cannot figure out why this isn't working. I created a new field called Modified On with Date/Time format in table1. I then...
  4. B

    Form Event Procedure Help

    I'm having some trouble coming up with a solution. I have three fields (generally entered in this order); Actual_Hours, Billed_Hours & Billed_Amount. I'm trying to get them working together, to establish a starting point, when Actual_Hours is entered. I was able to auto fill Billed_Hours from...
  5. S

    Event pocedure is preventing pasting copied cells

    Hi I am using an event macro that executes when the sheet deactivates. The event procedure sets ranges and resets value in a series of cells. When I copy a range of cells and leave that sheet, the event procedure executes and I lose the ability to paste the range I just copied to another...
  6. S

    Data Validation error Message 'application or Object Defined Error

    Hi I am using the following code to change the data validation source list based on the value in column "B" It was working fine and then stopped. I get the error message at the lines; .Add Type:=xlValidateList, Formula1:="=TempDescriptions" .Add Type:=xlValidateList...
  7. S

    Event Procedure tied to a specific cell not working

    Hi I know this had been asked, I want an event procedure to run only when a specific cell is change, such as "A3". I searched the board and modified some code that I found. I have been using the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range)<?xml:namespace...
  8. Default300

    ?How To: Return Name of Control from Within that Control's Event Procedure

    Is there a Keyword (such as "Me" or "Parent" etc.) that I could use to Return the Name Property of a Control from within that Control's Event Code. For example: Private Sub cboComboBox1_Change() Dim strControlNameCurrent As String Dim strControlNameOther As String 'With...
  9. N

    VBA UserForm - stopping the Textbox Enter event from running when selecting the frame

    Hi everyone, Long time reader, first time poster. App/OS: Excel 2003/Windows XP I am developing a VBA User form which contains three frames. Each frame contains a number of textboxes. Each textbox for date input has a textbox_Enter event which shows a date picker form (using the Calendar...
  10. alanw64

    How to create a dynamic event procedure?

    Ok, I might be making this harder than it seems, but after multiple searches here and elsewhere, I can't seem to find the answer. I have a macro that will add multiple worksheets. When the worksheet is added, is there a way to dynamically create code inside the Worksheet_Activate event...
  11. H

    worksheet_activate for Conditional Formatting

    Following is the code I regularly use when I need Conditional Formatting with more than four conditions. This code works great when you are typing in new data over the old, but I now need to base the formatting on data found in another sheet. For example, in Sheet1 and cell B2 I have a formula...

Some videos you may like

This Week's Hot Topics