My First Excel Program
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.
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