Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign a range to where the User Form places data
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign a range to where the User Form places data
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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Range with User Form? | Excel Programming | |||
Update Range from User Form | Excel Programming | |||
user form - data range | Excel Programming | |||
User Form - Range Selector | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming |