I gang

Macros/Form in Word and Excel.

Read the description first.

1)

a) Construct a macro that demonstrates how a word processing feature can be undertaken more efficiently if it is automated.

(i) Choose and state a text formatting feature, for example, underline text, embolden text, italicise text, etc.

(ii) (iii)

Construct a macro using the macro recorder. Link your macro to a toolbar button.

(iv) Word process a list of the steps that you have undertaken to construct the macro.

(v) Open a report that you have produced and demonstrate that the macro works. Selecting some text in the report and run the macro by selecting the toolbar button that it has been linked to.

2)

(i) Construct a macro that inserts a name and the current date into a header.

(ii) You should assign your macro to a toolbar button. (iii) Word process a list of the steps that you have taken to construct the macro.

(iv) Open one of the reports that you have produced and demonstrate that your macro works by running it via the toolbar button that it has been assigned to.

In Excel Sheet:

1)

To enter data into an interactive form when they input client data. Using spreadsheet software, produce an interactive form displays the following requests:

• Input staff number • Input staff surname • Input task number

2)

develop the interactive form that you have produced for task 1 (excel). Edit the macro so that the following actions occur:

(i)

After a task number is input, a message box is displayed that displays the following question:

Would you like to input data for a client? (ii)

Underneath the message displayed in the message box in Task 4(b) (i), there should be TWO (2) buttons to choose from:

• The first button should be labelled Yes • The second button should be labelled No

(iii)

If the Yes button is selected, another message box is displayed that displays the question:

If you do not want to input data for a new client select Cancel

(iv) Underneath the question in the message box in Task 4(b) (iii) there should be TWO (2) buttons to choose from:

• The first button should be labelled Ok • The second button should be labelled Cancel

Evner: Databehandling, Excel, Software Arkitektur, Visual Basic, Visual Basic for Apps

Se mere: form submit button microsoft word excel, copy form word excel, macros excel read html browser, vba extract text from word document to excel, transfer data from word forms to an excel worksheet, auto populate word document from excel, populate excel spreadsheet from word document, word to excel export macro, how to transfer data from excel to word automatically, export word 2013 form data to excel, extract data from word to excel vba, macros word excel, top form copying excel word, word macros form, copy form field word excel, copy form fields word excel, word macro read excel, can quickbook read excel generate reports, excel read pdf form data, create form letter word excel

Om arbejdsgiveren:
( 0 bedømmelser ) Kathmandu, Nepal

Projekt ID: #17975357

Tildelt til:

bayuardianto2

I think this is a challenging job and I will try it, please let me help you to do this job. Thanks & Best Regards, Bayu A

$10 USD in 10 dage
(0 bedømmelser)
0.0

7 freelancere byder i gennemsnit $16 på dette job

ddljitendra

My name is jeetendra kumar srivastava, I have working experience approx 20 yr data entry. Want a part time job work in home and study with children. I do work after gideline Thanks

$17 USD in 10 dage
(0 bedømmelser)
0.0
anthonysupan

Hi! I'm Anthony, I've lots of experience in creating different word typing and excel data, I just want you to know I can manage your project proposal. Have a nice day.

$12 USD in 10 dage
(0 bedømmelser)
0.0
creativesoft7

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do Flere

$16 USD in 7 dage
(1 bedømmelse)
0.0
saranshpachhai61

I am a person with great passion. I am well versed in various fields such as graphic design, data entry, content writing, Programmings such as C, C++, article writing and report writing, facebook marketing, forum posti Flere

$12 USD in 2 dage
(0 bedømmelser)
0.0
$25 USD in 5 dage
(0 bedømmelser)
0.0
webscraper24

Hi You are looking for an experienced person to Macros/Form in Word and Excel I'm well experienced in this area. I will try my best to provide you top-notch quality. I can assure you the quality. Knock me for furthe Flere

$20 USD in 3 dage
(2 bedømmelser)
0.0