By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 1,005 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

Separate UserfromTextbox Entries to Multiple Rows

P: 1
Hello,
I have several entries in a textbox and would like them to display on the worksheet in multiple rows as many entries long in the same column. Also,for the most accurate results, I'm not sure how I should seperate the data within the textbox either by commas or have each entry on seperate line. This is a partial execerpt from my macro:
Private Sub Item_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")

'find first empty row in database
iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _
SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1


ws.Cells(iRow, 16).Value = Me.Listbox1.Value
ws.Cells(iRow, 17).Value = Me.TextBox1.Value
ws.Cells(iRow, 18).Value = Me.TextBox2.Value

Thanks in advance for your help,
Sep 25 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.