Fungsi Membalik kalimat atau kata

September 19, 2008 at 3:45 pm 2 comments

Ini mungkin fungsi Iseng atau supaya orang tidak bisa membaca  … Karena kita membalik tulisan.  Caranya adalah:

  1. Klik Alt+F11 untuk membuka Visual Basic Editor (VBE).
  2. Dari menu Insert , pilih Module (untuk menambah sebuah module).
  3. Masukkan kode-kode berikut dalam module:
Function BalikText(text) As String

	Dim PanjangText As Integer
	Dim i As Integer
	PanjangText = Len(text)
	For i = PanjangText To 1 Step -1
		BalikText = BalikText & Mid(text, i, 1)
	Next i

End Function

Silahkan coba sendiri   yaitu  =BalikText(alamat sel yang ada textnya)    … dan ketawa sendiri

Entry filed under: Ms Excel. Tags: , , .

Fungsi Triwulan Excel Jadwal Angsuran Sederhana dng Excel

2 Comments Add your own

  • 1. dimasrheza  |  March 3, 2010 at 2:34 am

    briliant, nice blog

    Reply
  • 2. dssd  |  November 1, 2012 at 12:08 pm

    mantap hehehe

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 14 other followers

Blog Stats

  • 94,725 hits

Twitter Updates

Iklan


%d bloggers like this: