change cell

Hello! I'm quite new to the more advanced tools in Ecxel and I have never used VBA before, but I have some limited experience with programming in general. The worksheet is a calculator to help my colleagues calculate the prices of contracts before sending a quote to a customer. What I'm trying...

I want cursor to move from cell “L43” to cell “S28” after inputting data and pressing enter.

Hello, are you able to track when a cell interior colour index is changed to a specific value? For example when colour index changes from 16777215 which is white, within a cell in a specified range, is changed to .5296274 then a worksheet change event would occur and something happens.

Hello, I have data sets I want to have code for that if I select a specific column, cell it opens a userform. The data set starts with a number such as 9334231/1 below. It will always vary in length. then another number, just different, indicates start of a new data set. If I was to select...

Hello, I am trying to find a way how I can log all changes made to the workbook. I have found a perfect piece of code on a forum thread here. I will link the code: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim LR As Long, X As Variant If Sh.Name = "Log" Then...

I would like to print a worksheet changing only one field/cell (B27) with information from another worksheet ranges A1:A100. If there is no information in cell, would like it to skip.

I have created a macro that copies a concatenated series of cells then runs 'text to columns' on it. I want to repeat this process using the same cell to copy from (the text will change) but copy into a different cell i.e. the first time I run it I want it to start in E2 but the next time may...

Hi there, I am a teacher at a high school and am currently creating an Excel workbook to record students who need learning adjustments made. On the table I have various columns of data, with student names listed in column B with their CURRENT year level in column A. I’m not sure this...

i want to type something in "B1" and then if it is in sheet 1,2,5 it will get delete and then adds the word "changed" the next cell to the right in "Column B" Private Sub CommandButton2_Click() For Each cell In Range(Cells(1, "A"), Cells(Cells(Rows.Count, "A").End(xlUp).Row, "A"))...

Im looking for something very simple just to replace the field data of one field based on the entry of another. I used to know VB, not so much anymore, so here is a poorly written, multi lingual script that shows in essence what im looking to do, any/all help would be appreciated: Fields...

Every time I think I know what I'm doing with Excel Solver - I surprise myself (by what I apparently don't understand . . .). I'm trying to solve for the maximum number of company store "certificates" I need to buy, up to say a maximum of $600, in order to buy the maximum number of movie...