events

Hi, I have a little routine that is supposed to test that duplication does not occur. Problem is that if I use tbPPCode_Click the user may bypass it by using tab keys. If I use tbPPCode_Change the event triggers on the second key pressed. How can I force this routine to wait untill the client...

I have an excel application which automatically updates from over 50 files when it is opened. Recalculation seems to occur each time a sheet is refreshed, which makes opening rather lengthy. I know I can use an event (Worksheet_Open I believe) to turn off automatic recalculation, but what can...

hi, I have an excel (2007) .xlsm file with some macros assigned to buttons (shapes) Every thing is OK, but, after Uploading the file to portal by IBM WebSpher, and download by users or by me, there is a link problem. all the other macros (Events macro) are working fine but I can't use the...

Hi, Is there a way to toggle the Events somewhere in the options of Excel, without using VBA code?

Hi I'm using code so that when a workbook is read only, it treats it as saved, so the Save prompt doesn't come up. This is in in BeforeClose event. However, if a user opens the spreadsheet (as read only) and does work in it, without bearing in mind it's only read only, then it would not come...

Hi all, I have developed a set of extensive macro calculations that I now want to trigger when a data table is created. These calculations have numerous inputs, and the idea is that the user should be able to use the data table function in Excel to vary any one of these inputs and record the...

Hello All, I have several textboxes within a userform and was wondering if there was some way to utilize one KeyPress method for all of these, rather than having to put the code within each textbox KeyPress event. I read some where about using Handles at the end of KeyPress...

Hi All, How can I make my macro to run everytime I Double-Click on the cell "A2".

I have one worksheet that has a list of events for a three-month period. One column in this sheet displays the WEEKNUM for each event. In a separate sheet, I want to display only events with a WEEKNUM for this week. Do you know of a formula I can use (perhaps OFFSET?)??

Below is a code that most of you experts will realize right away that it will crash my excel document as soon as I run it. In each of my sheet names that begin with "Series" I have a data validation combo box embedded in the cell. Each time I select a certain value, I use the "SheetChange"...

Hi, I have a worksheet that is not responding to worksheet events as I expect. Code is as follows... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Not Intersect(Target, Range("E4:P4")) Is Nothing Then MsgBox "New Cell Selected" End...

Hi I have a problem in using the Worksheet Change event. My code checks the Target range named 'designStatus' and performs various checks and actions if the user changes this cell. My problem comes if the Target range does not equal 'designStatus'. In this instance, I would like the system...

Hi I have the following code in my Worksheet_Change module - each piece of code works fine, however, from time to time I am receiving an out of stack space error in Excel during execution. I do not think this code is formatted correctly for efficient use of the Worksheet_Change event (for...

Hi all, Changing userform styles to add a Max,Min,Restore menu buttons , to make the userform resizeable or to show its icon on the taskbar are techniques we can apply with relative ease with a couple of APIs however associating an event handler for each added functionality is a bit more...

Hi I need two worksheet change events in a worksheet This is what I have so far (code tested and works fine) ... Private Sub Worksheet_Change(ByVal Target As Range) Dim Answer As String Set isect = Application.Intersect(Target, Range("designStatus")) If Not isect Is Nothing Then [code...

Hi, I have a vision for greater convenience when using sharepoint. I want to have a calendar draw its data from several lower level calendars. So if a manager manages 3 projects, I want each project to have its own calendar, and I want the manager to be able to see the 3 calendars in one...

Hi, I have a worksheet with several text boxes, and when a specific text box is selected, I would like to run a macro. Much like what you might do using the Worksheet_Selection Change function. But, the Worksheet_Selection Change function seems to only respond to cell selection changes, not to...

I am looking for an equation that would to count the number 7 rolled before the point is established in a series of craps rolls For example, the following rolls occurred Roll 1 3 7 11 12 3 7 4 6 4 Roll 2 7 7 8 9 10 9 I want to count the number of 7 rolled before the point is...

I have a UserForm Listbox Called 'PressLossList'. I have a change event for it that works just dandy (wrapped in Sub PressLossList_Change() tags). I also want to have a different event for if it's double-clicked. For that I use this code: Private Sub PressLossList_DoubleClick() Dim c...

I have a Volume vs. Area plot. Here is the format of the worksheet length | width | depth | Area | Volume I would like to use chart events (Mouse Up event) to get me information about not only area and volume but also l, w, and d. I know that following code give me info about x and y (i.e...