Jika ingin icon vbExclamation dengan button pilihan Yes No dan Cancel, maka jumlah konstanta terkait
Contoh : MsgBox sTeksPesan, vbExclamation + vbYesNoCancel, sTeksTitel Regard, Kid. On Sat, Jun 11, 2011 at 11:11, STDEV(i) <[email protected]> wrote: > > > 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 >> >> >> >
