Thread: list boxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] halimnurikhwan@yahoo.com is offline
external usenet poster
 
Posts: 113
Default list boxes

Hi Lionel,
try this :
Sub Test()
Dim r as long
Listbox1.RowSource = ""
For r = 57 to 63
Listbox1.additem Sheets("step").Range("B" & r ).Value
Next r
End sub

lionel menuliskan:
i have list box in a form that needs to read a list from a range in a sheet
named "Step"
I have entered in the Row Source block "step!B57:B63"
When I run the procedure, the listbox comes up empty.
I have done this many times before without trouble.
Can you advise??
--
Lionel