simora
07-13-2010, 04:42 AM
I have a UserForm ( SalesForm) that has a ListBox
When I select a Name from the ListBox, it populates some fields on the UserForm.( SalesForm)
This is how I get the Rowsource
Set SourceRange = Range(ListBox1.RowSource)
I have another form ( NSF Form ) that is selected from the SalesForm UserForm
I DO NOT Unload the ( SalesForm)
How can I find out which row is selected in the listbox on the SalesForm UserForm from the NSF Form, so that I can post data to the same row of the person selected on the spreadsheet using the NSF Form to get the data.
I tried using
Set SourceRange = Range(SalesForm.ListBox1.RowSource)
then to post the data, I tried
SourceRange(ListBox1.ListIndex, 11).Offset(1, 0).Value = TextBox5.Value
The Set SourceRange = Range(SalesForm.ListBox1.RowSource) gives an error
Any ideas on how I can and should proceed.
Thanks
When I select a Name from the ListBox, it populates some fields on the UserForm.( SalesForm)
This is how I get the Rowsource
Set SourceRange = Range(ListBox1.RowSource)
I have another form ( NSF Form ) that is selected from the SalesForm UserForm
I DO NOT Unload the ( SalesForm)
How can I find out which row is selected in the listbox on the SalesForm UserForm from the NSF Form, so that I can post data to the same row of the person selected on the spreadsheet using the NSF Form to get the data.
I tried using
Set SourceRange = Range(SalesForm.ListBox1.RowSource)
then to post the data, I tried
SourceRange(ListBox1.ListIndex, 11).Offset(1, 0).Value = TextBox5.Value
The Set SourceRange = Range(SalesForm.ListBox1.RowSource) gives an error
Any ideas on how I can and should proceed.
Thanks