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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top