My First Excel Program
By agihcam
@agihcam (1914)
Philippines
June 2, 2008 11:30pm CST
Open new excel file.Right click on sheet1 then view code.On the left side,you can see VBAProject(Book1),right click on it and insert module.On the right white page,type the following;
Sub MyFirstExcelCode()
msgbox "Hi there!,It is my first excel code",vbinformation+vbokonly,"My First Code"
end sub
Close the VBE using x button or hit Alt + Q
on the excel sheet,click on Tools,Macro,Macros it will open macro display which highlights your code name,click on Options then type "z" on Ctrl+ field.Click OK then close the display box.
Now hold Ctrl then click on letter "z" from your keyboard.Good luck and happy excelling.
2 responses
@sircaido (162)
• Japan
3 Jun 08
You've got my attention and I followed what you said, wow I made my first program in excel, nice demo my friend. Now I knew how the program works in macro.
Do you have more? lol!
I want more, do you have any suggestion how to learn macro for free? Do you have any site offering that course for free?
Thank you in advance.
1 person likes this
