Government Funded PC Applications courses Southwark

...through code Stopping Code Excel Objects and their hierarchy Workbook Range Cell Worksheet Columns Rows Using the Offset property Using the object browser...

...with VAT added to it Returning a country based on a provided city Returning the last cell address in a range Returning the last row in a range Returning...

...for macros Customising the button Attaching a toolbar to a workbook Using VBA Why? Creating / deleting a toolbar Showing the toolbar Placing the toolbar...

...Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code. DESCRIPTION Anyone wishing to automate...

...field options Protecting forms Save forms data only Printing a form Macros and form fields Example form macros INTRODUCTION TO MACROS What is a Macro?...

...FORMS Introduction Built-In Dialog Boxes Predefined Dialog Boxes User-Defined Forms Adding Form Controls Form Control Properties Control and Dialog...