PDA

View Full Version : Move cell values and buttons up from application caller



bull699
02-16-2016, 03:20 PM
I've put together a data table that the user can add to. When a new row is entered, it comes with a 'delete' button which removes the row and the button itself.


So far so good, but I want the remaining data below the deleted row to move up one row to fill it's space. This includes the 'delete' button. Any good way to do this?


The data itself should be pretty straightforward, but the buttons seem a little trickier. I'm using a time stamp to uniquely identify each button (basically I've got more than one button attributed to each row, and when any one is pressed, I need them all on that row to delete, hence need to be uniquely numbered), so I can't reference the buttons directly. Is there a way to identify shapes underneath an application caller and do it that way?


Thanks in advance from a complete VBA newbie