VBA PPT Short Reference Sheet 1

Application Object In Microsoft VBA PowerPoint

Determines the working environment is PowerPoint or not:

Debug.Print Application Is PowerPoint.Application 'In PowerPoint will Prints: True

Selection Object In Microsoft VBA PowerPoint

The PowerPoint.ActiveWindow.Selection object in VBA contains whatever the user has selected.

The PowerPoint.ActiveWindow.Selection.Type properties in VBA consist of:

• shapes = ppSelectionShapes
• slides = ppSelectionSlides
• text = ppSelectionText
• nothing at all = ppSelectionNone

Creates Object Variables And Assign References

Dim pptPP As Presentation

Dim pptSld As PowerPoint.Slide

Dim pptShp As PowerPoint.Shape

'Assign Active Slide to Variable

Set pptSld = Application.ActiveWindow.View.Slide

'Assign slide by Index to Variable

Set pptSld = ActivePresentation.Slides(1)

Bibliography

https://learn.microsoft.com/ ( manual ebook )

https://www.autovbax.com/

http://www.pptalchemy.co.uk/

https://www.vbaplanet.com/

PowerPoint;Cengage

Microsoft PowerPoint;Microsoft Press

Fungsi MIN Pada Excel

Fungsi MIN Pada Microsoft Excel

Fungsi MIN digunakan untuk menampilkan nilai atau angka minimum (terkecil) yang terdapat dalam suatu sel/range atau beberapa sel/range data. Bentuk penulisan fungsi adalah sebagai berikut,

=MIN(number1;number2; ...)

Penjelasan argumen fungsi MIN.

Keterangan

number

dapat berupa angka/bilangan, sel atau range yang berisi angka atau nilai logika. Excel mengizinkan Anda untuk mengisi argumen maksimal sebanyak 255.

Fungsi MINA Pada Microsoft Excel

Fungsi MINA digunakan untuk menampilkan nilai terkecil dari sekelompok data tanpa mengabaikan jenis data teks atau logika. Bentuk penulisan fungsi adalah sebagai berikut,

=MINA(value1;value2; ...)

Keterangan

value

dapat berupa angka/bilangan, sel atau range yang berisi angka, teks atau nilai logika. Jika nilai logika diisi dengan TRUE, Excel memberi nilai 1 dan jika nilai logika diisi dengan FALSE, Excel akan memberi nilai 0. Anda diizinkan untuk mengisi sampai dengan 255 argumen.

Studi kasus berikut disajikan data yang diperlihatkan dalam gambar.dan table berikut ini:

	A	B	C	D	E	F	G	H	I	J	K	L
3		DATA		MIN		DATA		MIN		DATA		MIN
4		0.10		=MIN(B4:B16)		15.00		=MIN(F4:F16)		15.00		=MIN(J4:J16)
5		0.85				27.00				27.00
6		0.41		MINA		15.50		MINA		15.50		MINA
7		0.47		=MINA(B4:B16)		10.00		=MINA(F4:F16)		10.00		=MINA(J4:J16)
8		0.80				8.00				8.00
9		0.70				7.00				7.00
10		0.78				6.00				6.00
11		0.70				5.00				5.00
12		0.99				10.99				10.99
13		0.07				12.00				12.00
14		KOSONG				TRUE				FALSE
15		0.75				15.00				15.00
16		0.50				25.50				25.50

Soal:

• Input data di kolom B, dari B3 sampai dengan B16, seperti dalam tabel di atas.
• Tulislah fungsi MIN di kotak cell D4, H4 dan L4.
• Tulislah fungsi MINA di kotak cell D7, H7 dan L7

<< back to Study About Microsoft Office 1

Related Post

Learn Microsoft Windows ( Road Map )

Study About Java 1

Study About C and C++ 1

Study About Python

How To Check Python GTK Version

Prerequisites:

1. Install Python. In this example using Python 2.7.13
2. Install PythonGTK.

Tutorial

1. Open Command Prompt.

2. Running your Python interactive console / Python interpreter / Python shell by typing python.

3. Typing :
import pygtk

import gtk

print(gtk.pygtk_version)

print(gtk.gtk_version)

4. Then for print(gtk.pygtk_version) you get output similar to this :

(2, 24, 0)

5. Then for print(gtk.gtk_version) you get output similar to this :

(2, 24, 10)

<< back to Study About Python

Study About Python

Getting Started

• Default Python Path Installation
• Set Up The Python In Microsoft Windows 8
• Set Up The Python In Microsoft Windows 8 With Picture
• How To Check Your Python Version
• How-to-check-version-of-python-modules
• How To Check Version Of Tkinter ( Python )
• Command Prompt Path And Most Common Program
• Software Programming Environment Variable
• Uninstall Python Package

Tools

PyCharm IDE Parts

go to Learn Microsoft Windows ( Road Map ) >

Ribbon UI XML Namespace

You need to save the Custom Ribbon UI file in your office document (.xlsm, .docm, .pptm)

Use "Custom UI Editor For Microsoft Office", "Office RibbonX Editor" to make editing more easier.

You can use another XML (eXtensible Markup Language) editor, for example "Microsoft XML Notepad", "Oxygen XML Editor", "Alova XML Spy", "Liquid XML Studio" or other text editor and IDE for your option with XML plugin.

Microsoft Office 2007 Custom Ribbon UI Namespace

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">

file: customUI.xml

folder: \customUI

Microsoft Office 2010 Custom Ribbon UI Namespace

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

file: customUI14.xml

folder: \customUI

Microsoft Office 2010 Custom Ribbon UI DTD Schema

<Relationship Id="R43c63e08ca974dfc" Type="http://schemas.microsoft.com/office/2006/relationships/ui/extensibility" Target="customUI/customUI.xml"/>

file: .rels

folder: _rels

Bibliography

https://bettersolutions.com/index.htm

https://learn.microsoft.com/ ( manual ebook )

https://officeoneonline.com/index.html

https://vba.co.id/

https://www.brightcarbon.com/

http://www.pptalchemy.co.uk/

CSV Schema File

• A CSV (Comma Separated Value) schema file defines the structure of your data.
• Common file name for CSV Schema is schema.ini
• CSV Schema File is commonly using in ODBC Data Source Administrator

schema.ini example:

[CartoonCharacter.csv]

ColNameHeader=True

Format=CSVDelimited(;)

MaxScanRow=17

CharacterSet=OEM

DecimalSymbol=.

Col1="No" Float Width 3

Col2="Cartoon Name" Text Width 21

Col3="Description" Text Width 20

Save file as schema.ini

*.csv file example:

No;Cartoon Name;Description

1.;Bluey;Cartoon Character 1

2.;Peppa Pig;Cartoon Character 2

3.;Gudetama;Cartoon Character 3

4.;Mofusand;Cartoon Character 4

5.;Elsa;Cartoon Character 5

6.;Anna;Cartoon Character 6

7.;Spongebob Squarepants;Cartoon Character 7

8.;Finn;Cartoon Character 8

9.;Jake;Cartoon Character 9

10.;Minions;Cartoon Character 10

11.;Lightning McQueen;Cartoon Character 11

12.;Paw Patrol Pups;Cartoon Character 12

13.;Ladybug;Cartoon Character 13

14.;Tom;Cartoon Character 14

15.;Jerry;Cartoon Character 15

16.;CocoMelon;Cartoon Character 16

Save file as CartoonCharacter.csv

Bibliography

CSV Format File In Microsoft Excel

CSV On The Web 1

Simple Exception Summary In CSV Format

Study About Microsoft Office 1

NoteTab Menu 1

File menu, Edit menu, Search menu, View menu, Modify menu, Document Menu, Favorites menu, Tools menu, Help menu.

<< back to Learn Notepad++

<< back to  Learn Microsoft Windows ( Road Map )

Related Post

Notepad 2 Edit SubMenu