Excel - Form to link to spreadsheet

This is a 2nd repost of a job that I erased as a result of an admin error with the budget allocation - sorry for any inconvenience.

I am looking for an Excale VBA script (Compatible with Excel 2003 - 2010) that populates a form - as shown in the attached file.

There must be 4 text panes in the form. The first pane on the form contains a list of Tasks (The list of Tasks available is fixed). When the user clicks on the Task list, depending on what the user selects, a list of subtasks will be diplayed on the next pane from which the user can select a sub task. On selecting the sub task the third pane will be populated with the standard activities associated with that Task & Subtask combination. The contents of all three these panes are fixed and sourced from the values in the Database sheet containing the source values (see attached file for the desired structure). The fourth pane is an input text area where the user can add additional information. That information needs to be copied back to the database when the user clicks on the "Accept and Exit" button.

If the user comes back to that task at a later stage the contents of each of the panes needs to be shown - including any additional comments saved previously. In other words the form needs to be pre-populated based on the contents of the associated database sheet.

I have included a screen shot of the form (I have been working on it, but have run out of time to get it completed) so it shoud be relatively simple to create from that screenshot. Do not worry about the "Code & Colour on Sheet" input as this is not applicable

Skills: Excel, Visual Basic for Apps

See more: link form spreadsheet, link form attached spreadsheet, excel vba user form link spreadsheet, excel 2010 link user form spreadsheet, link form spreadsheet excel 2010, spreadsheet script, looking for job at excel, excel out source, what is vba in excel, vba error, three form, additional comments, budget spreadsheet, visual basic form excel, task allocation, spreadsheet input, excel visual basic, excel vba script, excel form, create spreadsheet, create additional applications, excel database visual basic, sheet excel job, simple vba excel script, excel colour

About the Employer:
( 21 reviews ) Sydney, Australia

Project ID: #2516439

Awarded to:


I have already done this type of task. Please check your mailbox for more details.

$40 AUD in 2 days
(22 Reviews)

12 freelancers are bidding on average $86 for this job


Excel Expert VBA coder here.....get it done in a day..

$60 AUD in 1 day
(78 Reviews)

Hello. We are a German Company with a team of 3 dedicated VBA developers and we've done the similar projects. We assume high quality work both in terms of technical background and time frame issues. Please check your More

$90 AUD in 2 days
(21 Reviews)

Hi, I can do it in excel 2010. Im programmer for years and very familair with VBA for excel automation. I suggest to add task id (unique) to track tasks. Best regards, Cuong NH

$70 AUD in 3 days
(20 Reviews)

Hello Peter, Ready to deliver our best [login to view URL] can develop the similar [login to view URL] for the project [login to view URL] can complete it ahead of [login to view URL]

$100 AUD in 3 days
(13 Reviews)

Hi, Am working on this. Will send you FIRST VERSION in next few hours. Best Regards, Naveen

$35 AUD in 1 day
(14 Reviews)

Please check PMB for details.

$80 AUD in 2 days
(11 Reviews)

We r excel expert macro expert from india

$65 AUD in 1 day
(15 Reviews)

hi im a visual basic programmer with experience for more than 7 years i can do your work and im so familiar with excel scripting.

$60 AUD in 4 days
(3 Reviews)

Dear ph1965, I have already finished your project. I have sent you ready file to check. I have based on information and data, that you were prepared.

$250 AUD in 2 days
(1 Review)

Hi, I have some very important suggestions regarding your requirement. Please check the same in PM and we can discuss more on this. Regards, Sumeet.

$80 AUD in 3 days
(2 Reviews)

Hello, Greetings from CIS (consulting and IT services) We have reviewed your project post and can help you to develop the project and make sure run successfully, and also glad to tell you we have developed many websi More

$100 AUD in 7 days
(0 Reviews)