Search results

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)...

In dutch

I am to old and to ugly to spend my time, post a real example.

That was your question

I don't know if this is what you want. The password is SPP

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

If I don't get an answer good luck

Can you make an example (manually) what your boss wants?

solution with vba

Doest this help? With conditional formatting only

Maybe something like this, your example doesn's say anything where we can work with.

Simple example. It is in dutch but the construction is the same

Example?

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.

Thank you @ETAF and @vletm . problem solved. Both you're suggestions are appreciated.

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...

Using Excel to create sticky notes , somebody an idea? You type an appontment in excel and an sticky note is created.

@ vletm, I like the solution with tables.

Hoi AliGW, Thank you my dear, it works perfect and vletm thanks also.

Thanks,I already looked there, but after a year in hospital, i can't follow these guidings anymore, i need simpler answers.

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.