VBA, Gung ho newbie - stuck at # 3 on the MVP

Gung ho newbie - stuck at # 3 on the MVP - VBA basics in 15 minutes

Author	Message
D #1 / 6	Gung ho newbie - stuck at # 3 on the MVP - VBA basics in 15 minutes I am afraid to admit that I never find Windows intuitive - maybe because I am left handed, I don't know, but it is always the simplest things which throw me. I have made a few macros using the recorder and have copied some from the MVP site successfully. Now I am ready to try VBA and when I read the "Getting to grips with VBA basics in 15 minutes I get stuck at: # 2 Press F7 to view a code window. I have a code window show up when I open VBA and all my macros are listed in it. # 3 Click in the code window and type ActiveDocument. My problem - since all my macros are listed in this document, I don't really want to type anything in it. I did try typing it in and then deleting it. But I would really like to have clean window to try these things in. Do I need to set something differently? Or what? Any suggestions for me? Thanks very much for your help. Diane
Sun, 28 Dec 2003 07:59:19 GMT

Mark Tangar #2 / 6	Gung ho newbie - stuck at # 3 on the MVP - VBA basics in 15 minutes Probably the tutorial assumes you have no macros yet. Since you do, just go the very bottom of the window, and on a new line, type: Sub xxx where xxx is not the name of any existing macro. As soon as you hit Enter you'll be placed between that line and an End Sub line (which will appear without you typing it) and can type code there without hurting any of your existing macros. ------ WWW: http://www.speakeasy.org/~mtangard ---------------------- ------------- "Life is nothing if you aren't obsessed." --John Waters --------------------------------------------------------------------- Quote: > I am afraid to admit that I never find Windows intuitive - maybe because I > am left handed, I don't know, but it is always the simplest things which > throw me. > I have made a few macros using the recorder and have copied some from the > MVP site successfully. Now I am ready to try VBA and when I read the > "Getting to grips with VBA basics in 15 minutes I get stuck at: > # 2 Press F7 to view a code window. I have a code window show up when I > open VBA and all my macros are listed in it. > # 3 Click in the code window and type ActiveDocument. > My problem - since all my macros are listed in this document, I don't really > want to type anything in it. I did try typing it in and then deleting it. > But I would really like to have clean window to try these things in. > Do I need to set something differently? Or what? Any suggestions for me? > Thanks very much for your help. > Diane
Sun, 28 Dec 2003 08:06:53 GMT

D #3 / 6	Gung ho newbie - stuck at # 3 on the MVP - VBA basics in 15 minutes Oh thanks so much Mark. You are a sweetie. Sorry I am so much trouble. Diane : Probably the tutorial assumes you have no macros yet. Since you do, : just go the very bottom of the window, and on a new line, type: : : Sub xxx : : where xxx is not the name of any existing macro. As soon as you : hit Enter you'll be placed between that line and an End Sub line : (which will appear without you typing it) and can type code there : without hurting any of your existing macros. : : ------ WWW: http://www.speakeasy.org/~mtangard ---------------------- : ------------- "Life is nothing if you aren't obsessed." --John Waters : --------------------------------------------------------------------- : : : > : > I am afraid to admit that I never find Windows intuitive - maybe because I : > am left handed, I don't know, but it is always the simplest things which : > throw me. : > : > I have made a few macros using the recorder and have copied some from the : > MVP site successfully. Now I am ready to try VBA and when I read the : > "Getting to grips with VBA basics in 15 minutes I get stuck at: : > : > # 2 Press F7 to view a code window. I have a code window show up when I : > open VBA and all my macros are listed in it. : > : > # 3 Click in the code window and type ActiveDocument. : > : > My problem - since all my macros are listed in this document, I don't really : > want to type anything in it. I did try typing it in and then deleting it. : > But I would really like to have clean window to try these things in. : > : > Do I need to set something differently? Or what? Any suggestions for me? : > : > Thanks very much for your help. : > : > Diane
Sun, 28 Dec 2003 08:46:46 GMT

Mark Tangar #4 / 6	Gung ho newbie - stuck at # 3 on the MVP - VBA basics in 15 minutes Piffle. We were all, each of us, "trouble" of this sort at one time. It's the easiest way to learn, so don't hold back. Most (maybe all) of the people answering questions here get some kind of rush from it or they wouldn't do it. ------ WWW: http://www.speakeasy.org/~mtangard ---------------------- ------------- "Life is nothing if you aren't obsessed." --John Waters --------------------------------------------------------------------- Quote: > Oh thanks so much Mark. You are a sweetie. Sorry I am so much trouble. > Diane > : Probably the tutorial assumes you have no macros yet. Since you do, > : just go the very bottom of the window, and on a new line, type: > : > : Sub xxx > : > : where xxx is not the name of any existing macro. As soon as you > : hit Enter you'll be placed between that line and an End Sub line > : (which will appear without you typing it) and can type code there > : without hurting any of your existing macros. > : > : ------ WWW: http://www.speakeasy.org/~mtangard ---------------------- > : ------------- "Life is nothing if you aren't obsessed." --John Waters > : --------------------------------------------------------------------- > : > : > : > > : > I am afraid to admit that I never find Windows intuitive - maybe because > I > : > am left handed, I don't know, but it is always the simplest things which > : > throw me. > : > > : > I have made a few macros using the recorder and have copied some from > the > : > MVP site successfully. Now I am ready to try VBA and when I read the > : > "Getting to grips with VBA basics in 15 minutes I get stuck at: > : > > : > # 2 Press F7 to view a code window. I have a code window show up when I > : > open VBA and all my macros are listed in it. > : > > : > # 3 Click in the code window and type ActiveDocument. > : > > : > My problem - since all my macros are listed in this document, I don't > really > : > want to type anything in it. I did try typing it in and then deleting > it. > : > But I would really like to have clean window to try these things in. > : > > : > Do I need to set something differently? Or what? Any suggestions for > me? > : > > : > Thanks very much for your help. > : > > : > Diane
Sun, 28 Dec 2003 11:27:18 GMT

Howard Kaiko #5 / 6	Gung ho newbie - stuck at # 3 on the MVP - VBA basics in 15 minutes THe most cost effective way to learn this stuff is to read one, or more books. See the list of Word VBA books a tmy URL below. -- Please post your response to the newsgroup. http://www.standards.com/ipusers/standards; Word macros, including converting from WordBasic to VBA; Technical writing and reviewing; Standards ------------------------------------------------ Quote: > I am afraid to admit that I never find Windows intuitive - maybe because I > am left handed, I don't know, but it is always the simplest things which > throw me. > I have made a few macros using the recorder and have copied some from the > MVP site successfully. Now I am ready to try VBA and when I read the > "Getting to grips with VBA basics in 15 minutes I get stuck at: > # 2 Press F7 to view a code window. I have a code window show up when I > open VBA and all my macros are listed in it. > # 3 Click in the code window and type ActiveDocument. > My problem - since all my macros are listed in this document, I don't really > want to type anything in it. I did try typing it in and then deleting it. > But I would really like to have clean window to try these things in. > Do I need to set something differently? Or what? Any suggestions for me? > Thanks very much for your help. > Diane
Sun, 28 Dec 2003 19:45:35 GMT

D #6 / 6	Gung ho newbie - stuck at # 3 on the MVP - VBA basics in 15 minutes Thanks for the suggestions for books. Diane : THe most cost effective way to learn this stuff is to read one, or more : books. : See the list of Word VBA books a tmy URL below. : : -- : Please post your response to the newsgroup. : : http://www.standards.com/ipusers/standards; Word macros, including : converting from WordBasic to VBA; Technical writing and reviewing; Standards : ------------------------------------------------ : > I am afraid to admit that I never find Windows intuitive - maybe because I : > am left handed, I don't know, but it is always the simplest things which : > throw me. : > : > I have made a few macros using the recorder and have copied some from the : > MVP site successfully. Now I am ready to try VBA and when I read the : > "Getting to grips with VBA basics in 15 minutes I get stuck at: : > : > # 2 Press F7 to view a code window. I have a code window show up when I : > open VBA and all my macros are listed in it. : > : > # 3 Click in the code window and type ActiveDocument. : > : > My problem - since all my macros are listed in this document, I don't : really : > want to type anything in it. I did try typing it in and then deleting it. : > But I would really like to have clean window to try these things in. : > : > Do I need to set something differently? Or what? Any suggestions for me? : > : > Thanks very much for your help. : > : > Diane : > : > : :
Wed, 31 Dec 2003 08:51:06 GMT

Page 1 of 1

[ 6 post ]