Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why doesn't macro work?
I got this code her:
Private Sub UserForm1_Initialize() Dim rFound As Range Dim sFirstAdd As String Dim rLook As Range Dim rValue As Range Set rValue = Ark1.Range("A5") Set rLook = Ark11.Range("A10:A250") Me.ListBox1.ColumnCount = 4 Set rFound = rLook.Find(rValue.Value, , , xlWhole) If Not rFound Is Nothing Then sFirstAdd = rFound.Address Do With Me.ListBox1 .AddItem rFound.Row .List(.ListCount - 1, 1) = rFound.Value .List(.ListCount - 1, 2) = rFound.Offset(0, 2).Value .List(.ListCount - 1, 3) = rFound.Offset(0, 5).Value End With Set rFound = rLook.FindNext(rFound) Loop Until rFound.Address = sFirstAdd End If End Sub I have made command button on sheet1 which display userform with listbox, but listbox is empty. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro will not work - Please help | Excel Discussion (Misc queries) | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
Macro works Macro does not work | Excel Discussion (Misc queries) | |||
how to get a macro to work | Excel Discussion (Misc queries) | |||
Macro won't work on other PCs - HELP! | Excel Programming |