Search results

Fisrt off all your example is not complete, we can't do about it., a question, did you change office 32 bit to office 64 bit?

Do you mean something like this? Select product in combobox and see result in listbox.

What is the reult you want? Example?

No clear. Do you search on product, date or unit? What do you mean by combobox cannot list repeated products, what is de difference between product A in unit 3 and product A in unit 7 and product A in unit 47??

Sorry, this is not a photoshop forum, we can't do anything whit a picture, we need an excel example.

This code belongs in the sheet code not in a module. Right click on the sheet tab, then paste the code in programmcode....

With this tool you can extract hyperlinks from PDF to CVS, don't ask me how. https://pdfcandy.com/

What use is a picture that no one can read? More, what does a picture in a Excelforum? This is not a photoshop forum.

Try it without (delete) Or Dim Cancel As Integer

What about? (Without a decent example.) ElseIf YesNo = vbCancel Then ' If Cancel clicked Cancel = True 'Exit Sub End If End Sub

You can forget PDF with office 2007, or the update from 2007. It is time you update office 2007 Something like this. https://www.gamers-outlet.net/en/buy-office-2021-professional-plus-phone-activation

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.