View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
yoram yoram is offline
external usenet poster
 
Posts: 22
Default controlsource cells in listobox

i'm trying the following code for your idea:
Private Sub UserForm1_Click()
ListBox1.Value = Worksheets("InternalForm").Range("c12").Value
ListBox2.Value = Worksheets("InternalForm").Range("d12").Value
End Sub

it doesn't seem to work. thanks for the help