Morning

I have a button which reads in file data, it appends the data into a detail sheet and then summerises the content in a summery sheet.

If it is a new file it dynamically creates an entry on the summary sheet (row) and creates an ole checkbox and assigns a linked cell in the same row as the newly inserted row on the summary sheet.

I wish to run a refresh subroutine each time the value of the (checkbox or the linked cell changes) , at the moment I have a refresh button , but I would like to automatically trigger the refresh. There are currently around twenty checkboxes on the sheet, I use these to set advanced filter ranges based on te checkbox value.

The problem is they are dynamically created and I dont know how to detect a change, I have tried the Worksheet_selectionChange but this does not detect the change, and I dont know how to create a dynamic onclick event

Thanks Andre