A VBA module that adds worksheets and forms to an Excel workbook
- or -
Post a project like this2883
£150(approx. $188)
- Posted:
- Proposals: 16
- Remote
- #1153099
- Completed
Business Consultant, Website Design, Website Development, PHP, WordPress, Web App, Mobile App, Branding, Designer, Business Plans, Business Support, Presentation, Adviser, Analyst, Strategist, Advisor
City of London
MBA Global Business Strategy, Export Bussiness Developement, Study Methods Teacher, Excel Developer, Amateur artist, Seller,
Lima
Google Sheets Automation, Apps script, Excel VBA Expert, Qlikview, WordPress Hack Fix, Proofreading
Bangalore
4864955794091237383123182712280281201491117760810830581025327917239101190516719
Description
Experience Level: Intermediate
The attached Excel workbook, PPH067_003-Excel workbench_001, has two worksheets: Command and Template. The Command worksheet uses columns A to D named as follows:
A Action
B Name
C Description
D Built on
You are asked to write a VBA procedure, CreateProjects, which, when executed (by hitting F5 when in CreateProjects), does the following:
1 Reads each populated line in the Command worksheet
2 If a line contains ‘B’ in the action field then:
a. Add today’s date to Col D in the command worksheet
b. Add a worksheet
c. Give the added worksheet the same name as in Field B of the command worksheet
d. Copy the contents of the Template worksheet into the added worksheet
e. Add ‘Name’, ‘Description’ & ‘Built on’ in the command worksheet to the added worksheet.
3 For each added worksheet, generate user form of the same name and populate it with a Tab Control object with pages as named (in the current template there are four: ’QML’, ‘Scratch’, ‘HTML’ & ‘Reports’, but this may vary).
4 Each page should have a large text box (able to accept multi line as well as scrolling) and a row, at the bottom, of command buttons as specified (in the current template there are four: ’Clear’, ‘Refresh’, ‘Deploy’ & ‘Save’, but this may vary).
5 There is a command button, ‘Show form’ in cell A1. Clicking on this button should:
a. Show the form
b. Change the caption on button to ‘Hide form’
We think this could be about a day’s work for a competent VBA/Excel developer. The job should be completed within 7 calendar days from commissioning.
A Action
B Name
C Description
D Built on
You are asked to write a VBA procedure, CreateProjects, which, when executed (by hitting F5 when in CreateProjects), does the following:
1 Reads each populated line in the Command worksheet
2 If a line contains ‘B’ in the action field then:
a. Add today’s date to Col D in the command worksheet
b. Add a worksheet
c. Give the added worksheet the same name as in Field B of the command worksheet
d. Copy the contents of the Template worksheet into the added worksheet
e. Add ‘Name’, ‘Description’ & ‘Built on’ in the command worksheet to the added worksheet.
3 For each added worksheet, generate user form of the same name and populate it with a Tab Control object with pages as named (in the current template there are four: ’QML’, ‘Scratch’, ‘HTML’ & ‘Reports’, but this may vary).
4 Each page should have a large text box (able to accept multi line as well as scrolling) and a row, at the bottom, of command buttons as specified (in the current template there are four: ’Clear’, ‘Refresh’, ‘Deploy’ & ‘Save’, but this may vary).
5 There is a command button, ‘Show form’ in cell A1. Clicking on this button should:
a. Show the form
b. Change the caption on button to ‘Hide form’
We think this could be about a day’s work for a competent VBA/Excel developer. The job should be completed within 7 calendar days from commissioning.
Geoffrey R.
98% (48)Projects Completed
59
Freelancers worked with
44
Projects awarded
65%
Last project
4 May 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies