on change

Hello all! I have a combobox with a dropdown of information that has multiple columns (from a query). In a normal (single) form, I normal use the 'on change' event and reference the other various columns that wasn't selected to change other text boxes on the form. For example...

I have a Workbook with 31 Worksheets. On each Worksheet I have 3 columns total (A,B,C) and each entry is two rows. I need help to change the interior color of A1 & A2 (and each pair with the same reference) when a value is entered into the top row (for each pair) of the B Column. I will also...

I need to setup a macro to run on cell change (e.g. by using "Private Sub Worksheet_Change(ByVal Target As Range)"). Case: technician will use bar scanner to scan several batches. Some times there are two batches with the same master ID and in these cases I need the code to find the next vacant...

New to VBA but feel that using it is the solution to this question: I have text in column F (cells 20 to 199) that changes automatically based on pre-determined time constraints (this is done via an IF formula). I want the 4 cells adjacent to F to clear contents when the text in F changes...

Hello Excel Experts, I am new to the forum. Anyway, I have a hard time describing this issue so I'm not sure if it has been posted previously. If you know of a thread, please let me know. We currently have a workbook where the users can employ selections via column filters. They would use...