Showing related tags and posts accross the entire site.
-
Jake The code per se looks fine. I can see a few places where I would make some changes, but it should not cause a crash. i would suspect the userforms to be the issue as unless you specifically release the memory, you will get all kinds of problems (IMO) eventually. Make sure when you display the UserForm...
-
Rob I'm sure there is, if you have the data in an Excel sheet it can be copied off somewhere at set intervals. There may be an event you can use to to this just after the data refreshes (Worksheet_Change() etc (This code takes the data in A1:A30 and pastes it to the same range on sheet2 if there...
-
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...
-
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...
-
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 ...