Excel VBA

Excel Vba 1°­ : https://goo.gl/wmB8fz

¸®º»»ç¿ëÀÚ ÁöÁ¤

´ÜÃß(ActiveX ÄÁÆ®·Ñ)

Microsoft Visual Basic for Applications

Private Sub start_Click() ¡¦ End Sub

Sheet2.Cells(1, 1) = "¾È³çÇϼ¼¿ä. VBA ½ÃÀÛÇÕ´Ï´Ù." : Sheet2 â¿¡ 1Çà 1¿­¿¡ "¾È³çÇϼ¼¿ä. VBA ½ÃÀÛÇÕ´Ï´Ù.¡±¸¦ ÀÔ·Â

Sheet2.Cells.ClearContents : Sheet2ÀÇ CellsÀÇ ³»¿ëÀ» ´Ù Áö¿ò

Excel ¸ÅÅ©·Î »ç¿ë ÅëÇÕ ¹®¼­

¡¡

Excel Vba 2°­ : https://goo.gl/R5oyQK

If Á¶°Ç Then  / ¸í·É¹® / Else  /End If

If Á¶°Ç Then  / else if ¸í·É¹® then / Else  /End If

¡¡

Excel Vba 3°­

For i=1 to / ¸í·É¹® / Next

¡¡