One userform for many uses
I am creating a project list program in excel and need to have the
ability to 1)click a shape (assign a macro to a box, I know that part) 2)have a user form pop-up with a textbox and some comboboxes on it (can do this) 3)When the user clicks the ok box, the contents of the textbox lets call it textbox1 should insert itself into the next available empty row below a range titled "header" 4) The "header" range contains things like importance, start date,etc. I can make this happen for one task, but how can I recycle the same userform to serve the same function. I'd also like to put an edit button next to each project on the list so that they can continually edit and update each project. How can I build a userform with multiple relative controlsources. Think of Outlook handles a task list. I essentially want to re-create the same thing in excel with customized contents and functionality. Thank you for any help. |
All times are GMT +1. The time now is 07:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com