![I've made a macro that works, but I need to recreate it for every new item. I'm trying to find a way to automate it so it doesn't need input every time. : I've made a macro that works, but I need to recreate it for every new item. I'm trying to find a way to automate it so it doesn't need input every time. :](https://preview.redd.it/ive-made-a-macro-that-works-but-i-need-to-recreate-it-for-v0-7b8rs1pnkf7b1.png?width=719&format=png&auto=webp&s=7e581d37d07e93b0f42298d1a4e12e966962697c)
I've made a macro that works, but I need to recreate it for every new item. I'm trying to find a way to automate it so it doesn't need input every time. :
![VBA Blogs: Shape References < Blog | SumProduct are experts in Excel Training: Financial Modelling, Strategic Data Modelling, Model Auditing, Planning & Strategy, Training Courses, Tips & Online Knowledgebase VBA Blogs: Shape References < Blog | SumProduct are experts in Excel Training: Financial Modelling, Strategic Data Modelling, Model Auditing, Planning & Strategy, Training Courses, Tips & Online Knowledgebase](https://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2019/vba/shape-references/image2.png/f32e5a15e2cf9c3e4d2d058458ce054d.jpg)
VBA Blogs: Shape References < Blog | SumProduct are experts in Excel Training: Financial Modelling, Strategic Data Modelling, Model Auditing, Planning & Strategy, Training Courses, Tips & Online Knowledgebase
![excel - Trying to update an existing textbox, but getting an "Object Required" error - Stack Overflow excel - Trying to update an existing textbox, but getting an "Object Required" error - Stack Overflow](https://i.stack.imgur.com/nX8qB.png)
excel - Trying to update an existing textbox, but getting an "Object Required" error - Stack Overflow
![Comment masquer ou afficher une certaine forme en fonction de la valeur de cellule spécifiée dans Excel? Comment masquer ou afficher une certaine forme en fonction de la valeur de cellule spécifiée dans Excel?](https://cdn.extendoffice.com/images/stories/doc-excel/doc-hide-unhide-shape-based-on-cell-value/doc-hide-unhide-shape-based-on-cell-value-1.png)
Comment masquer ou afficher une certaine forme en fonction de la valeur de cellule spécifiée dans Excel?
![remove vba password | How to unlock Protected Excel VBA Project and Macro codes without password - YouTube remove vba password | How to unlock Protected Excel VBA Project and Macro codes without password - YouTube](https://i.ytimg.com/vi/QV56TWT4nKw/maxresdefault.jpg)
remove vba password | How to unlock Protected Excel VBA Project and Macro codes without password - YouTube
![Macro excel runtime error 1004:cannot paste the data. -only happens occasionally enough to be frustrating. Suggestions? : r/excel Macro excel runtime error 1004:cannot paste the data. -only happens occasionally enough to be frustrating. Suggestions? : r/excel](https://external-preview.redd.it/u8FRpjeBWR-j45k0S4-UIDH42g-U9b_YFeybaPpZ4Dg.jpg?auto=webp&s=6bb3e7052e5e8141843da56b5d9626979ed88c59)