Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
userform carwincarber New Users to Excel 0 October 23rd 05 06:59 PM
Access from add_in userform to main template userform.... Ajit Excel Programming 1 November 18th 04 05:15 PM
Linking userform to userform in Excel 2003 missmelis01 Excel Programming 2 August 27th 04 08:07 PM
Userform inside another userform Ryan Excel Programming 0 April 23rd 04 08:01 PM
userform billQ Excel Programming 3 November 19th 03 03:41 AM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"