dkipnai
05-12-2010, 09:18 AM
Hi Friends:
My name is Kipnai.
Background:
I am a newbie. I have already developed a portion of CODE within a form and several control buttons. I have a data sorter which from LISTBOX-A and popupates LISTBOX-B.
QUESTION:
Please help me with a CODE thread which can Grab the data from a LISTBOX-B and insert it on COLUMN "G1" on a spreadsheet.
The following code by Simon works only for one line (sentence)
Private Sub CommandButton10_Click()
Range("G1") = UserForm2.ListBox2.Value
End Sub
Thank you Simon for such a quick response. I can see some light at the end of the tunnel. But I thick now I need a CODE TO LOOP through the LISTBOX-B BUT HOW do I go about it? Please could you add more light?
Please help.
Kipnai
My name is Kipnai.
Background:
I am a newbie. I have already developed a portion of CODE within a form and several control buttons. I have a data sorter which from LISTBOX-A and popupates LISTBOX-B.
QUESTION:
Please help me with a CODE thread which can Grab the data from a LISTBOX-B and insert it on COLUMN "G1" on a spreadsheet.
The following code by Simon works only for one line (sentence)
Private Sub CommandButton10_Click()
Range("G1") = UserForm2.ListBox2.Value
End Sub
Thank you Simon for such a quick response. I can see some light at the end of the tunnel. But I thick now I need a CODE TO LOOP through the LISTBOX-B BUT HOW do I go about it? Please could you add more light?
Please help.
Kipnai