Does this help? It is not clear to me.
Push change code button instead of register.
Private Sub CommandButton2_Click()
Set ws = Worksheets("Register")
Lr = ws.Cells(Rows.Count, 2).End(xlUp).Row
With ws
.Range("B" & Lr) = TextBox1.Value
If TextBox2.Value <> "" Then .Range("C" & Lr) =...
Try this,
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim rng As Range
Set rng = Range("B3:AG20,B24:AG41,B45:AG62")
t = Target.Value
If Not Intersect(rng, Target) Is Nothing And Target.Count = 1 Then
If WorksheetFunction.CountA(Range(Target.Offset(, 1)...
It has nothing to do with your language, I lost time to find a solution dat was not representative,
The only thing I ask post a real example, instead wasting my time
... Original writing has cleared ...
Moderator Note: You should able try to find something positive about this thread.
Otherwise, You could write eg Take Care.
Belleke As written in Forum Rules:
Please use language which conveys respect, appreciation and love.
You are making this difficult, for yourself why 2 tables?
In my example hoover over ABC 0.25(B2 with the red triangle) or klik klik on GHI 7(D7), see the results and say what you prefer
Not sure what you want, and wat you ask is not possible as far as I know but what is posible is if the cell is empty you can give it a color, if it is not empty another color.
You have an number in Cell D18, if cell in cell D21 is empty cell E21 should be empty, if cell D21 has a value cell E21 should give de difference between D18 and D21.
If positive in black if negative in red.
See example.
I am not sure but I think you mean this?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Target
ay = .Row
ax = .Column
End With
With ActiveSheet
If ay > 7 And .Cells(ay, "J") <> Empty Then
xx = .Cells(7...
I have this formula:
=VLOOKUP(H1;Info1!A:B;2;FALSE)
So when I type a number in H1, the value should appear in columm B, next to the number.
This is working for 1 worksheet, but I want it working for al worksheets.
In my example, if I type 5 ,the word Praag Should appear next to Number 5.