Terima kasih Mbak. Salam, Hendrik Karnadi
________________________________ From: STDEV(i) <[email protected]> To: [email protected] Sent: Saturday, June 11, 2011 11:11:08 Subject: Re: Fw: [belajar-excel] macro excel Begini pak, ceritaknya MsgBox kan punya syntaks seperti ini MsgBox(prompt[, buttons] [, title] [, helpfile, context]) Nah 48 itu untuk mengisi argument (parameter) ke 2 (button) biasabya kita isi dengan misalnya : VbInformation, VbExclamation dsb yg kita isikan itu adalah contans yg sudah ditentukan oleh VBA dan tiap konstata itu punya VALUE misalnya vbInformation = 64 vbExclamation = 48 seperti daftar di bawah ini Argument BUTTON pada MsgBox Function Constant Value Description vbOKOnly 0 Display OK button only. vbOKCancel 1 Display OK and Cancel buttons. vbAbortRetryIgnore 2 Display Abort, Retry, and Ignore buttons. vbYesNoCancel 3 Display Yes, No, and Cancel buttons. vbYesNo 4 Display Yes and No buttons. vbRetryCancel 5 Display Retry and Cancel buttons. vbCritical 16 Display Critical Message icon. vbQuestion 32 Display Warning Query icon. vbExclamation 48 Display Warning Message icon. vbInformation 64 Display Information Message icon. vbDefaultButton1 0 First button is default. vbDefaultButton2 256 Second button is default. vbDefaultButton3 512 Third button is default. vbDefaultButton4 768 Fourth button is default. vbApplicationModal 0 Application modal; the user must respond to the message box before continuing work in the current application. vbSystemModal 4096 System modal; all applications are suspended until the user responds to the message box. vbMsgBoxHelpButton 16384 Adds Help button to the message box. VbMsgBoxSetForeground 65536 Specifies the message box window as the foreground window. vbMsgBoxRight 524288 Text is right aligned. vbMsgBoxRtlReading 1048576 Specifies text should appear as right-to-left reading on Hebrew and Arabic systems. 2011/6/11 hendrik karnadi <[email protected]> >Mbak Siti, > >Mau nanya ..., angka "48" dalam code di bawah ini (yang juga sering muncul >dalam >code yang Mbak buat) berfungsi untuk apa ? > >MsgBox "data MTBF belum diisi!", 48, "Hayyah!" > > >Salam, >Hendrik Karnadi > > >
