Can you help, I have extracted information from an excel spread sheet into a userform total 17 columns and 300 row data into a listbox.
On the userform I added a comments box under control17 which needs to be updated by sales. So, the idea is that they pick a row from the list and then they add comments on that particular row. And the update should be for that particular row or line.
Here's my code for cmdSend command
Dim ws As worksheet
Set ws = Worksheets("Sheet")
Dim newRow As long
newRow = Application.worksheetFunction.CountA(ws.Range("Q5")) + 5
ws. Cells(newRow, 17). Value = Me.Control17.Value.
I am running in this problem. If I select row 23 from the list and want to update with a comment, the input on the spread sheet is showing up in Q5 not in Q23. Can you help
Thanks
Ocran
On the userform I added a comments box under control17 which needs to be updated by sales. So, the idea is that they pick a row from the list and then they add comments on that particular row. And the update should be for that particular row or line.
Here's my code for cmdSend command
Dim ws As worksheet
Set ws = Worksheets("Sheet")
Dim newRow As long
newRow = Application.worksheetFunction.CountA(ws.Range("Q5")) + 5
ws. Cells(newRow, 17). Value = Me.Control17.Value.
I am running in this problem. If I select row 23 from the list and want to update with a comment, the input on the spread sheet is showing up in Q5 not in Q23. Can you help
Thanks
Ocran