Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform | New Users to Excel | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming | |||
Userform inside another userform | Excel Programming | |||
userform | Excel Programming |