• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Belleke

  1. Belleke

    I need your help with ListBox Search

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

    I need your help with ListBox Search

    Like this?
  3. Belleke

    Userform Update Data

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

    Filter Listbox using textbox

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

    Userform Update Data

    Version 4.:)
  6. Belleke

    Filter Listbox using textbox

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

    select cell content copy to textbox in userform opened modeless

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

    Userform Update Data

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

    Filter Listbox using textbox, Select one result and assign values to label

    @ 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.
  10. Belleke

    Filter Listbox using textbox, Select one result and assign values to label

    @ 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.
  11. Belleke

    Userform Update Data

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

    Userform Update Data

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

    How to Unlock PDF With PDF Unlocker ?

    Google is your best friend. Search on unlock pdf.
Top