Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |