Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform
Hello,
I need to create a sheet of 7 columns. To avoid errors I would like an userform to be used to input the data. How can I make sure that the data inserted in the userform goes into the next available row? I use office 11. Thanks a lot |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform
Hi, you can use the code below to give you the last used cell in that
column, then insert the data in the next cell by adding 1: ' the "A" value in Cells(Rows.Count, "A") represents the ' column where you wish to find the last used cell CountData = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row Cells(CountData + 1, 1) = myVariable HTH--Lonnie M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA userform | Excel Worksheet Functions | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming | |||
Userform inside another userform | Excel Programming | |||
userform | Excel Programming |