Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a listbox in a userform the user makes his multiple selections, I need
the macro to search the range database to find the matching row and place "Paid" in it there. The following code assumes: the entries in your listbox correspond to the rows of the range Database, but that isn't correct they don't correspond. So can anyone show me how to fix this. Tom said to record a macro using the EDITFIND method but i couldn't make that work. Thank you so much for you help! 'Set sh = Worksheets("ProduceData") 'Dim rng As Range 'Set rng = sh.Range("Database").Columns(1).Cells 'Dim i As Long 'Dim rw As Long ' 'For i = 0 To lstData.ListCount - 1 ' If lstData.Selected(i) Then ' rw = rng(i + 1).Row ' sh.Cells(rw, "ag").Value = "Paid" ' End If 'Next -- Though daily learning, I LOVE EXCEL! Jennifer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If cell entry does not match options = error | Excel Discussion (Misc queries) | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
entry must match value in range | Excel Worksheet Functions | |||
Find closest text match for each unique entry in a list | Excel Discussion (Misc queries) | |||
How do I set up Data entry to match My Application Form | Excel Discussion (Misc queries) |