Tutorial Photoshop pilihan lainnya hanya untuk anda : Membuat Foto Terpisah-Pisah Pertama-tama buat sebuah dokumen baru dengan ukuran 640 x 500 px. Lalu dengan menggunakan Gradient Tool (G) warnai...
Breaking News
Sunday, September 30, 2012
Friday, September 28, 2012
VBA: Application Open FileName List all Excel File types
When you are showing a open dialog box to the user to select an excel file, by default the filter would be *.* which will show all files including excel files. and .xls and .xlsx will show only 97-2003...
Wednesday, September 26, 2012
VBA: Array - Return common values from two arrays
The below function will return the common values that are exist in two different arrays. This can be achieved by nested-looping concept, but this is an effective way :).IsInArray is an another function....
VBA: Distinct Array items - Remove duplicates
If you have an array with repeated items and want distinct items, then copy the below source code. IsInArray is an another function. Dont forget to include it....
VBA: IsInArray - Find a value in array items
The below script will be used to get to know whether a particular item exists in a array or not. Instead of looping this would be faster. -1 Then wordList = Join(arr, ",") ' start from the allegedly...
VBA: Cell Data Validation list to an array
The below function will be used to get list of Cell data validation and store into an array variable. This code is needed when checking the cell value as whether it is picked from the validation drop-down...
Tuesday, September 25, 2012
Cara Membuat Puzzle Gambar Burung

Membuat PuzzleHari ini saya akan menunjukkan cara untuk membuat efek sederhana namun sangat menarik. Ini terlihat seperti kaca mosaik berwarna atau puzzle. Langkah 1. Pilih gambar yang ingin diterapkan...
Monday, September 24, 2012
VBA Excel : Sheet Named range into Array
The below code will be used to access the list of named-range values and pass to an array variable....
Thursday, September 20, 2012
Menggambar Star Wars lightsaber Yang Keren

Membuat Star Wars Lighsaber1. Buka Fotoshop dan masukan foto yang akan Anda tambahkan lightsaber. Saya menggunakan foto ini. 2. Menggunakan Rectangular Marquee Tool (M) ciptakan sebuah persegi...
Monday, September 17, 2012
Download Uninstaller All in one Portabel Untuk Windows

Ada banyak pihak ketiga uninstallers dengan pilihan yang tersedia. Hari ini saya tersandung ini uninstaller kecil yang menyenangkan disebut Geek Uninstaller. Ini adalah aplikasi portabel yaitu tidak...
VBA - Extract notes section from PPT

The below code will be used to extract the notes section from Powerpoint slides to excel sheets range. We have seen a similar example of copy-pasting data from excel to powerpoint. This is a reverse...
VBA - Unzip files using VBA

The below code will Unzip a *.zip file to a specific folder. We have already seen couple of examples like 'Accessing system special folders' and 'Creating shortcut of an system application', This code...
VBA - Protect Sheet from User / Allow macro

Generally, if you want your vba code to run on a protected sheet, you wrap your code in unprotect/protect statements in every procedure or function. You also have to remember to protect the sheet in...
VBA - Export to Powerpoint

The below code will be used to copy paste a excel range (named range) to a powerpoint slide, this code has an ability to add new slides (at the End/Beginning) if you run a loop for 'N' number of slides....
VBA - Download files from sharepoint

The below VBA code will be used to download files from a sharepoint folder at one-click. I have got this code through surfing, this is quite usefull for the people who involves their day to day job...
Append string to a existing notepad (.txt) file in sharepoint
The below code will be used to append string to an existing text file in a sharepoint folder, you can do the same function with an existing folder in your computer/ shared folder.e.g. When you want...
Sunday, September 16, 2012
Mengatasi Blackberry Yang Hilang

Blackberry merupakan salah satu platform ponsel smartphone terlaris di Indonesia saat ini. Banyak dari kalangan masyarakat menggunakan Blackberry untuk kegiatan sehari-hari bahkan untuk keperluan bisnis...
Mengatasi Laptop Yang Hilang

Mungkin anda pernah merasakan perasaan yang sangat jengkel ketika anda kehilangan/kecurian Laptop anda. Tetap saat ini tidak perlu terlalu khawatir, karena sekarang sudah ada software yang dapat melacak...
Saturday, September 15, 2012
Membuat Foto Menjadi Lukisan Minyak

Lukisan Minyak Tutorial ini mengajarkan Anda bagaimana mengkonversi gambar normal Anda ke lukisan minyak. Buka gambar yang akan dikonversi ke sebuah lukisan cat minyak: - Tekan control + j untuk...
Subscribe to:
Posts (Atom)