Dear All Terima kasih banyak atas penjelasan dan bantuannya,
Salam Abdul Hamid ----- Original Message ----- From: siti Vi To: [email protected] Sent: Wednesday, April 14, 2010 10:04 AM Subject: Re: [belajar-excel] Data Validation betul kata pak Hendrik... Pada saat "dilepas" memang 'ListFillRange' tsb sengaja tidak di sort dulu; untuk membuktikan bahwa ketika di box ComboBox diKETIKKAN "A" atau abjad/karakter (X) lain, si combo akan mampu "mengejar" Item "X????.." pertama di urutan manapun Item tsb berada..., begitu juga ketika diketikkan karakter ke dua, ke tiga dst, selama masih ada item yg cocok... Selain dengan mouse-pointer mengklik tombol dropdown nya, ataupun dengan mengetikkan input nya, combobox 'beneran' (setelah mendapat fous) juga dapat di mainkan dengan tombol Panah Atas /Bawah /Kiri /Kanan. Masih banyak "perilaku" lain yg dapat diatur melalui kotak properties nya tanpa pemrograman. dan.... dengan pemrograman, akan lebih banyak hal dapat diatur, yg kadang-kadang berupa hal yg sebelumnya kita sangka "tidak bisa" ------------------------------------------------------------------------------ ----- Original Message ----- From: hendrik karnadi Sent: Wednesday, April 14, 2010 9:26 AM Kalau boleh nambahin sedikit, Agar tampilan Combonya bisa sesuai keinginan, sel B4:B33 perlu disort dulu. Salam, Hendrik Karnadi ------------------------------------------------------------------------------ From: siti Vi <[email protected]> Sent: Tuesday, April 13, 2010 17:56:24 mungkin yg dimaksud oleh pak Abd Hamid seperti kemampuan ComboBox beneran... .. kalau begitu.. pakai saja Combobox Beneran.. DISCLAIMER --------------- "This email and any files transmitted with it are private and confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. If you are not an intended recipient, you are hereby notified that any disclosure, copying, or distribution of this email, and/or taking any action based on its content, is strictly prohibited, and you should: (i) immediately delete this email and its attachments from your system, and (ii) inform the sender by reply email that you are not an intended recipient. Please note that any views or opinions presented in this email are solely those of the author/sender and do not necessarily represent those of ANJ Agri Group. ANJ Agri Group does not accept (i) any liability for its employee's communications that are against ANJ Agri's core values and/or outside the scope of employment and (ii) any damage caused by any virus transmitted by this email. Details can be found at: http://www.anjagri.com/disclaimer.htm";
