Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Event procedure » VBA (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site

  • Beforeclose event VBA question

    I would like to receive an email notification with a hyperlink to an excel workbook whenever someone completes said workbook (actually a customized template we use for each of our individual projects). After a little digging, one approach seems to be to create a beforeclose event with a customized dialog...
    Posted to VBA (Forum) by Anonymous on Fri, Mar 21 2008

  • Using VBA for Drag-and-Drop Data entry

    Hello. Here is my goal in its simplest form. I have a list of data in column A (for example, A5:A10). I have a row of boxes (merged cells) in row 2. I would like to write VBA code that would allow me to click on a piece of data from column A, "drag" it to one of the boxes (merged cells), and...
    Posted to VBA (Forum) by Anonymous on Thu, Jan 31 2008

  • Re: Add event to new worksheet using VBA

    Hi Anonymous! This is how I would add a new worksheet and attach the "Calulate" event handler (the example shows a message box each time the calculate event is triggered): Private Sub NewSheet_Click() Dim oXl As Application: Set oXl = Application oXl.EnableEvents = False oXl.DisplayAlerts ...
    Posted to VBA (Forum) by Pedro80 on Wed, Jan 9 2008
Page 1 of 1 (3 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.