Recent content by Belleke

Hi, Version 2. When you enter new data, the table is sorted (A-Z).

Like this?

I don't know how to mark this question as Solved. Is there not a button on top of this thread? Thanks for the feedback.

Don't be,we all have to learn. Glad to help.:)

Version 4.:)

Hi Fred, This is an easy one:) In your code you have With Sheets("Guests").ListObjects(1) ListObjects(1) means a table but in your example you don't have a table. Solution: insert a table in the guests sheet. See attached.

With the outlook add-in LINK

Glad to help.

Like this? Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 3 Then UserForm1.TextBox1.Text = CStr(Target.Value) End Sub

Now you have a combobox in the search section where the case numbers are sorted descending .

@ Fred Wayne, This is a forum rule. Start a new post every time you ask a question, even if the theme is similar. Next time, don't break in anyone else's thread but start a new thread. For your question. The guests that do not meet the search criteria disappear from the listbox. Also use a table.

@ ryan guadalupe My version: the employees id that do not meet the search criteria disappear from the listbox. Also use a table. Click in the listbox to fill the labels.

Hi, I've adjusted Question 1. For question 2. Step 1. You search for the case#, the numbers that do not match the search criteria disappear from the list. Step 2 When you have found the right case # you have to click on the right case in the list. Step 3Then make the changes in the textboxes...

Hi, Like this? Select a record in the list to edit. You can search on Case# and Name.

Google is your best friend. Search on unlock pdf.