Update data records
Closed
eexpert
Posts
2
Registration date
Friday June 7, 2013
Status
Member
Last seen
June 28, 2013
-
Jun 28, 2013 at 02:09 AM
Blocked Profile - Jun 28, 2013 at 07:46 AM
Blocked Profile - Jun 28, 2013 at 07:46 AM
Related:
- Update data records
- Ps3 update - Guide
- Psp update - Guide
- How to update emojis - Guide
- Play store update - Guide
- Tmobile data check - Guide
1 response
Good Morning.
My idea was to build a userform that finds the next cel in a range of 999, and insert it. If you need more cells, extend the cell count from 999 to N.
Make a userform with a TextBox. Keep the textbox name as TextBox1
Create a CmdButton, keep its name CommandButton1.
now attach the follwoing code to the commandbutton1.click
Dim LastRow As Object
Set LastRow = Sheet1.Range("a999").End(xlUp)
LastRow.Offset(1, 0).Value = TextBox1.Text
TextBox1.Text = ""
now, just keep your userform open, and enter into the textbox.
This is a direction and advisement. I am sorry for not providing a turn key solution.
My idea was to build a userform that finds the next cel in a range of 999, and insert it. If you need more cells, extend the cell count from 999 to N.
Make a userform with a TextBox. Keep the textbox name as TextBox1
Create a CmdButton, keep its name CommandButton1.
now attach the follwoing code to the commandbutton1.click
Dim LastRow As Object
Set LastRow = Sheet1.Range("a999").End(xlUp)
LastRow.Offset(1, 0).Value = TextBox1.Text
TextBox1.Text = ""
now, just keep your userform open, and enter into the textbox.
This is a direction and advisement. I am sorry for not providing a turn key solution.
