16.value

Hi, I've got a very basic if statement in VBA that color codes cells and writes text in an adjacent cell when conditions are met. The code is as follows and works exactly as I need: If Cells(rowCount, 15).Value = Cells(rowCount - 1, 15).Value And Cells(rowCount, 16).Value <> Cells(rowCount...

Hello, I have a Listbox which in the Properties window I have Set ColumnCount to 3; ColumnHeads to 0; and ColumnWidth to 100 pt; 100 pt; 100 pt. I want to populate the Listbox with Sheet3 Values from Cells(6, 14)-Cells(11, 14) to Listbox Column 0 and for Listbox Column 1 and 2 from two...

Hello all, I have managed to break an excel reporting workbook I was working on and I would greatly appreciate any help you could provide with this issue. The problem is with running a macro in the Excel workbook. The userform opens fine so I can enter data, but clicking the macro button on...

I'm at the end of my long process of VBA learning/Macro building. I am organizing the way my Macros work and in attempt at changing the look, layout and operation I've decided it would be best to have all my Macros stay in a locked workbook, but all my results return on a brand new workbook. I...

Someone please, for the love of God, tell me what my code is missing so I can move on. I keep getting the "NEXT WITHOUT FOR error, and it won't run my macro. I know this has to be a simple fix, but I've been up since 5am... my brain is too fried to look up anymore answers. Thanks Excel Giants...

I am trying to account for non-numeric values at the end of my string. I input MSP just to test if the code would work with my data set. THE PROBLEM: "MSP" can be any combination of letters and I need to account for all variations. The part of the code in PURPLE has no effect on the data...