asc2010
asked on
Excel Command Button to Clear Sheet and Display Shapes
Many thanks to rorya for his awesome skill in providing this UDF!!! I've tried to create a command button to clear the shapes and call the function, but have been unsuccessful. I would greatly appreciate an example with instructions on how to use a command button to call this function and display my shapes. cmdbtnEE.xlsm
Rory Archibald
You don't need a button - you just need to move the function code from the worksheet module into a normal module in the workbook. It automatically creates and deletes shapes as required.
ASKER
My spreadsheet does not delete the shapes after the percentage is changed. I moved the function back into the module as suggested. Do I need to change something else? cmdbtnEE.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
rorya,
Thank you so much for clarifying this!! I noticed the with statement that deletes the shapes. I thought it was not working because I moved the shapes away from their original position. Once moved, they remain on the sheet. I will leave them in place! Thanks again!
Thank you so much for clarifying this!! I noticed the with statement that deletes the shapes. I thought it was not working because I moved the shapes away from their original position. Once moved, they remain on the sheet. I will leave them in place! Thanks again!