Macro to create new button

levy77

Board Regular
Joined
May 7, 2019
Messages
67
Does anyone have any experience with a macro the creates a new button, the new button created then has code created for it based on a template so that when it is run it will do as specified.

It creating a list that has a button on each row where you can delete that line or tick done. I also have another button at the bottom of the page called add item.

When the add item button is pressed, it will add a row to the list and also create a new tick boxes of that row and a delete button for that row, is there some way I can have them buttons automatically updated with code to either tick that row or delete that row?
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

levy77

Board Regular
Joined
May 7, 2019
Messages
67
To give a basic idea, this is sort of what it looks like
EXCEL_LIST.png
 

Watch MrExcel Video

Forum statistics

Threads
1,114,017
Messages
5,545,517
Members
410,689
Latest member
ConfuzzledThomas
Top