#1
|
|||
|
|||
Add a button to add a line
Hi, I would like to create a button that would add a new line in my form and at the same time pushing the other lines down one . That would serve for anybody not to familiar with the program to add new info by just clicking on the button and filling the info on the line. Thanks very much for the help. |
#2
|
|||
|
|||
.
Code:
Sub insertrows() ActiveCell.EntireRow.Offset(1).Resize(1).Insert Shift:=xlDown End Sub If you click on A7, then run the above macro, the new line will be added on A8. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create a "Font color" button and a "Highlight text" button in the Quick Launch toolbar ? | gloub | Word | 12 | 02-19-2019 03:19 PM |
Usability of space between final line of body text and footnote separator line | Swarup | Word | 6 | 07-28-2018 12:51 PM |
How to change the default features for AutoShape horizontal line (button 'Insert horizontal line') | 534tomasz | Word | 6 | 10-13-2016 02:33 AM |
how can I cut and paste a line in page1 to page 2 by clicking a button? | esco | Excel | 11 | 12-10-2013 10:48 AM |
How to run two button macros with one button? | Geza59 | Excel Programming | 1 | 02-14-2013 12:11 AM |