In Progress

PowerPoint Macros in VBA

Specifications for PowerPoint Template modifications. Please provide a quotation and expected delivery date.

On creating a new presentation in PPT 2003 on using the Template:

An Input form to display asking:

Do you want to add the presenter’s name and date of presentation to the Title slide?

If user click’s no: remove bottom text box from Title slide which contains the words “Add name here Day Month year”.

If user click’s yes:

Display another input form with the following fields:

Date of presentation: ____________________

Presenter’s name: ____________________

Please control the date format to display as 3 June 2009 but not 03 June 2009 (ie month and year in full – single digit for 3). The user should be able to type 3 space 6 and when they tab to the next field date converts to the above format.

They should also be able to type: 3 Jun or 3 June or 3/6 and it should convert to the above format and default to the current year.

When the user click’s OK, the text box to be filled in with the results of the date and presenter’s name fields.

It is important that the code will run from anywhere in the presentation and it will insert the Presenter’s text box on the Title Slide only.

Accelerator keys for input fields.

Cancel button on input form.

The text box measurments are to be:

Position – horizontal 2.2 from Top left corner

Position – Vertical 17.22 from top left corner

Text box internal margin:

Left .25 Right .25 Top .13 bottom .13

No Fill No Line

Box 16.80 cm long to match one in ‘Remove text [url removed, login to view]’ template.

Font in text box:

‘Add name here plus 3 spaces using spacebar after this text’ = White Arial 25 point bold.

‘Day Month Year’ = Colour R150 G150 B150 Arial 25 point (regular)

New macro

Scenario

The user has now been working on the presentation for some time. They change their mind regarding having the Presenter’s name text box on the Title Slide and need to remove it. Or have removed it and now want to insert it again.

Is it possible to create code that will check the Title Slide and if the Presenter’s text box is present, delete it.

If the text box is not present, insert Presenter’s text box as per code above, displaying the input form for the fields etc.

The button to run this macro to be named: Show/Hide text box on Title Slide. Position the button on the Formatting toolbar to the right of the location of the default ‘New Slide’ button.

We recorded macros and stored in the ‘Remove text [url removed, login to view]’ file – this is what they are doing – they are to help you understand what we are wanting to achieve.

Macro3 – inserts text box on Title Slide.

This is a recorded macro – can you code as per above? Ie when the button

It is important that the code will run from anywhere in the presentation and it will insert the Presenter’s text box on the Title Slide only.

Macro 1 – Remove text box

This pre-recorded macro doesn’t work because the text box number is modified each time a new text box is added via Macro3.

Please create code that will consistently delete the Presenter’s text box (that has been inserted by Macro3 above) at the bottom of the Title Slide only.

New Macro

Create an autonew and autopen macro (or whatever is required) that will remove the New Slide button and Bullets button found on the Formatting toolbar in PowerPoint on creating a new presentation based on attached template or opening a presentation based on the attached template.

Create an autoclose macro (or whatever is required) that will on closing presentation based on the above template, reinstate the above buttons (ie reset the Formatting toolbar). This code will be added to three templates named: [url removed, login to view], [url removed, login to view] and [url removed, login to view] so must not refer to ‘Remove text [url removed, login to view]’ in the code.

_____

Please confirm how we distribute this code to end-user, ie. PPA or embedded in templates?

This peoject is urgent and must be completed within 7 days.

Skills: Visual Basic

See more: powerpoint vba, powerpoint macros, powerpoint macros vba, input box ppt, vba ppt, code input text powerpoint presentation, horizontal position powerpoint vba, powerpoint macro delete text, codes power point log, powerpoint macro accelerator, vba insert text box powerpoint slide, powerpoint vba code, vba powerpoint code, powerpoint macro insert text using input box, create format text box ppt vba, vba powerpoint position horizontal, day name vba powerpoint, powerpoint macros vba code, macro input box powerpoint, code input text powerpoint, vba powerpoint position text, vba ppt position horizontal top left corner vba, add vba macro ppt add, vba point, vba macros powerpoint

About the Employer:
( 1 review ) wellington, New Zealand

Project ID: #451459

Awarded to:

johnsinit

Dear Sir/Madam! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$88 USD in 2 days
(8 Reviews)
3.7

6 freelancers are bidding on average $88 for this job

srinichal

Can deliver the requirements once chosen for the bid

$80 USD in 4 days
(27 Reviews)
5.2
nmppatel

I am a VBA expert. I have very good experience with VBA Excel/Word/Power Point. I have completed many projects in VBA skill. I will provide quick & professional service.

$60 USD in 0 days
(18 Reviews)
4.7
crajeshbe

Hi Good day, Expert in Power Point VBA. Please check PM for my solution. Regards [url removed, login to view] B.E

$150 USD in 2 days
(8 Reviews)
4.1
arlee04

hi, i can do this job, i work on VB.NET i can do this job well

$50 USD in 0 days
(0 Reviews)
0.0
ioanaprof

Dear Mr / Ms Please have the kindness to check Project Message Board. Thanks

$99 USD in 4 days
(0 Reviews)
0.0