ExcelBanter - Excel: useform and shapes

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel: useform and shapes (https://www.excelbanter.com/excel-programming/367330-excel-useform-shapes.html)

Greg[_31_]

Excel: useform and shapes

How can I check whether the new selection is a Shape (e.i. chart) and
load the userForm
accordingly (without button) ?
How can I take the changes I have made to settings inthe UserForm and
apply them to the current shape (without button) ?

Greg

All times are GMT +1. The time now is 07:07 AM.