lst

Each row in the database is assigned a unique ID number (5 digits long) I want to be able to enter than ID number in a textbox in a userform and have the row information (4 columns total) displayed in a listbox. I want the listbox to update after each 5 digit long ID number entry so I can keep...

Hi, I found this as an option but I would like to expand on it if possible. Is it possible to use something like this =OR(CELL("row")=CELL("row",A27)) which highlights the row of a selected cell with the sub below? Id like to select a row then hit an ADD button, and it run the routine below...

I am comparing each cell in 1 column to each cell in a 2nd column (ex: C5:C500 to R5:R100) and if they match copy A:M of the row that C was on to SHEET4. Then move on the next row. I have been getting help and now getting frustrated and running out of time. Here is what I have. How does it look...

I need to update a column for each item selected in a Multi Select Listbox on a Userform. I'm using this to load the Listbox; With Sheet5 Dim Cl As Range Dim Lst As String For Each Cl In Range("A2:A42") If Cl <> "" And Cl.Offset(, 2).Value > 1 Then If Lst = "" Then Lst = Cl.Value Else Lst =...

Hi everyone I need to add a text 'P-' to the cell text in column F based on the value of column M. If column M's cell value is 'Test', then 'P-' have to add to the text in column F e.g. P-XYZ123 I have setup code as below, however it doesn't work: Dim Lst As Long, r As Long Lst = Range("A" &...