I know very little about VBA but I created a simple If/ElseIf code that is apparently too large because when I make the necessary change on the spreadsheet that runs the code it gives me a "Compile error: Procedure too large" message. Essentially, the user has a drop down list in each cell O31...
i have added the following code to my worksheet_change event and getting the error while running this code on Excel 2007 but working well on Excel 2013.
Can any body help to solve the issue as i am trying to calculate the things for both column value change. The error message is as: "No...
I have the below code that isn't doing what I'd like and I think I know what the issue is but I can't figure out the solution. Basically there are two cells "ShBal" and "BanBal" with numbers and if they match then the Match subroutine runs. BanBal is manually entered by the user and is constant...
I have a worksheet change macro that both updates an offset cell value with a date & a selection of cells with corresponding offset dates, however I am trying to update it so that it only inputs date if the offset cell is blank. Here is the code that works:
Private Sub Worksheet_Change(ByVal...
I have code that watches three different columns for changes.
It works great when only one cell changes at a time.
But if I copy and paste multiple cells of data in to the columns at a single time, it doesn't work.
I am pretty sure that I know why, but I can't figure out how to change it to...
I'm trying to call a macro using a Worksheet_Change Event but everytime I run it nothing happens. The event itself works great and recognized that the macro doesn't exist after I tried deleting it. I've also tried testing my macro using the Immediate Window feature and everything worked as...
I have a Workbook_SheetChange event for another workbook (other than the workbook that holds the code). At the end of a lengthy Sub, I call for the Sub that defines the Workbook's name that the event needs to work for:
I have a worksheet with a Worksheet_Change sub in it.
I have two sets of code in it.
Each set, individually, works as planned (tested). But when together, for some reason only the first set is catching correctly.
Here is the code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)...
I have a sheet with two blocks of data. On both blocks, I want to hide a different number of rows, using the following code. The thing is that VBA says I can't have two of the same. Is there a way to have one (or more) macro(s) have multiple Worksheet_SelectionChange(ByVal Target...
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("B2:B5")) Is Nothing Then
Cancel = True
ActCol = Activecell.Column
According to above codes, If the user change the value of B2 to B5 and press "tab" on...
I am planning to build one dashboard using work sheet change but not sure how to work with this option. My objective is to display list of fields based one cell value.
For example in A2 cell if you select "Fruit" then below automatically list of fruits should reflect and it should...
I have a simple log file with a couple of columns to log events. One row for each event.
Every cell in a row is manually entered and there are no macro's or formula's yet.
To prevent mistakes I now want to make a modification in column A... the date column.
As soon as one of the other cells in...
I've been trying to combine to separate change events in my VBA code. The first allows users to insert hyperlinks into specific columns and the second enables multi-select drop-downs in other cells.
The problem is I can't get them to work together. One always over rides the other. I've read...
I have this code here that simply turns the cells to uppercase.
For Each x In Range("C3:H200")
x.Value = UCase(x.value)
Does anyone know how would I adapt this code so that I can run in a sheet tab (Private sub...
Im ok at writing some simple code in vba but when it comes to looping the code I always screw it up!
I have a code that is working and doing what I want it to do, except I have to re write this for 10000 cells! which is extremely time consuming, as you will see I have shown the exact...
I am trying to get a message box to fire automatically based on a cell value. Here is the setup:
I have a "configurator" tab (Sheet 2) that has an ActiveX drop down box with a list of names that corresponds to a table of names/job titles on a logic tab (Sheet 3). When you select your name on...
Good evening all,
I am looking into rolling out a sharepoint adoption at our company, using the co-authoring capabilities of Excel 2016 with OneDrive/Sharepoint to enable sharing of macro-enabled workbooks with userforms etc (at last we can do this!)
I am however hitting a snag with...
I have two worksheet changes that I am having trouble to combine so that the changes work at the same time. The two changes do affect the same cells, but one hides the whole row and one stops specific cells from being deleted.
Here are the two codes:
Private Sub Worksheet_Change(ByVal...
I have a range of column headers that is transposed from a list in column B. When a value from column B changes, I have a macro that will copy those values and transpose them into row 8, starting with R8. I want to prevent the user from changing the column headers.
I want the column and the...
Never been too good at passing variables, but can usually keep it simple enough to get by. Not this time however.
I have a macro that works okay and part of this calls another macro. The second macro passes 2 public variables and this seems to work okay. As part of the second macro however I...