How can I rceive the information in my listbox

[Joep1972]

Hi,

Can somebody help me with linking a range of cells out of my worksheet "test" to my listbox1 in my userform1.

thx

Joep

 

[RobBroekhuis]

userform1.listbox1.rowsource = sheets("test&quot.range("A1:A10&quot

Rob

 

[Joep1972]

Hello Rob,

I've got the following,

Private Sub CommandButton1_Click()
'
' Annuleerinvoerform1 Macro
' De macro is opgenomen op 25-11-2002 door Joep Spronck.
'

'
UserForm1.Hide

End Sub

Private Sub CommandButton3_Click()
Worksheets("Test&quot.Cells(14, 8).Value = Me.TextBox1.Text
Sheets("test&quot.Cells(14, 9) = Me.Calendar1.Day
Unload Me
End Sub

Private Sub ListBox1_Click()
UserForm1.ListBox1.RowSource = Sheets("test&quot.Range("g14:g27&quot
End Sub

I don't get the information shown,

can you please help.

Joep

 

[RobBroekhuis]

Put the .rowsource assignment in your

sub userform1_initialize()

it needs to be set just once, and left alone. Rob

 

[RobBroekhuis]

Oops - the rowsource property is actually text, so that you need:

UserForm1.ListBox1.RowSource = "test!g14:g27"

Sorry for the misinfo

Rob