How to write a Excel VBA and run it?

jkpd2000 · May 9th, 2002, 03:10 PM

I am new to this Excel stuff. Can any one tell me how to write a small VBA code in excel and run it, step by step. Or any tutorial is available anywhere on web.

thanks

James · May 9th, 2002, 03:15 PM

Hi jpk2000,

You may want to record a simple macro yourself and then after recording go back and have a look at it. This will give you an idea of what VBA created.

James

Paul B · May 9th, 2002, 07:46 PM

Have a look at http://www.angelfire.com/biz7/julian...ans_macros.htm

dsnbld · May 9th, 2002, 11:16 PM

Paul, thanks for posting that link. Great site.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 03:10 PM	#1
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	I am new to this Excel stuff. Can any one tell me how to write a small VBA code in excel and run it, step by step. Or any tutorial is available anywhere on web. thanks

May 9th, 2002, 03:15 PM	#2
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi jpk2000, You may want to record a simple macro yourself and then after recording go back and have a look at it. This will give you an idea of what VBA created. James

May 9th, 2002, 07:46 PM	#3
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Have a look at http://www.angelfire.com/biz7/julian...ans_macros.htm

May 9th, 2002, 11:16 PM	#4
dsnbld Board Regular Join Date: May 2002 Posts: 206	Paul, thanks for posting that link. Great site.