Assign a range to where the User Form places data
in [Programming]
|
Prev: How to find the owner of the active excel workbook
Next: Multiply cells and format to currency in text format
From: GWYZOR on 22 Dec 2009 17:14 I have a user form with several text boxes and list boxes. I am having difficulties getting the data to be put in the right range. It goes to the next unused line and uses that line, however, there are couple lines at top of spreadsheet, so it uses those, instead of starting on line 4 as I would like. I have tried to select a range in which the lines are to be written, but not getting good results. Undoubtedly there is an easy answer. Thanks in advance for your attention.
From: Per Jessen on 22 Dec 2009 17:24
Hi As always post your macro for comments. Try and see if this can help you: TargetRow=Range("A" & Rows.Count).end(xlup).Row If TargetRow<4 then TargetRow=4 Range("A" & TargetRow)=TextBox1.Value Range("B" & TargetRow)=TextBox2.Value Hopes this helps. .... Per On 22 Dec., 23:14, GWYZOR <GWY...(a)discussions.microsoft.com> wrote: > I have a user form with several text boxes and list boxes. I am having > difficulties getting the data to be put in the right range. It goes to the > next unused line and uses that line, however, there are couple lines at top > of spreadsheet, so it uses those, instead of starting on line 4 as I would > like. I have tried to select a range in which the lines are to be written, > but not getting good results. Undoubtedly there is an easy answer. Thanks > in advance for your attention. |