add-in combo box date excel 2000 excel 2002 excel 97 excel XP format formatting formula grouping loan - amortization macros subtotal sum excel tutorial workbook worksheet vba
| Article | Body |
| 53 | I am new to VBA & VB. I wish to establish if it is possible to launch a .wav (and/or) on opening an Excel 2000 worksheet...(Note: not workbook,) I have perused newsgroups archives and web with Google and have been unable to locate any previous discussion on this. I would appreciate any direction to any tutorial or tips page that is relevant and could assist me. Many thanks Chris Hawkins |
| 63 | John Walkenbach has some example code for playing a .wav file: -walk.com/ss/excel/tips/tip59.htm -walk.com/ss/excel/tips/tip87.htm Should get you going into the right direction... HTH Jason Atlanta, GA -----Original Message----- I am new to VBA & VB. I wish to establish if it is possible to launch a .wav (and/or) on opening an Excel 2000 worksheet...(Note: not workbook,) I have perused newsgroups archives and web with Google and have been unable to locate any previous discussion on this. I would appreciate any direction to any tutorial or tips page that is relevant and could assist me. Many thanks Chris Hawkins . |
| 310 | Hi Paul, Topics in Excel, or topics in Math. It probably won't make much difference because you can probably find what you want in the links on tutorials on my /dmcritchie/excel/excel.htm#tutorial also note that Microsoft has materials K-12 kindergarten through grade 12 on their site, and the university tutorials are great for students who have to use Excel particularly for those who need to use Excel without taking a course in Excel. HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Paul Reeves" <pwr@22balmoral.freeserve.co.uk wrote in message news:u83Tr48FCHA.2520@tkmsftngp13... I'm a maths teacher and would like to use excel as a resource. Does anyone know where I can get some ideas as to the topics I could cover, and how I could cover them? Paul |
| 726 | Phil - For a line chart, a log X scale is undefined. I would suggest instead to use a regular XY scatter chart, make the X axis logarithmic, and use data labels on the data points (labels option, not values). If you absolutely need axis labels at other intervals besides the decades, try to generate a simulated log axis with an arbitrary scale, as demonstrated on Tushar Mehta's web site (-mehta.com) with his flexible log scale axis tutorial, or by one of the fake axis tricks on my website (/jonpeltier/Excel/Charts, specifically the arbitrary axis scale, probability axis, or reciprocal axis examples). - Jon _______ In article <124e401c21c4b$dc5f4030$39ef2ecf@TKMSFTNGXA08, pperry@acsoft.co.uk says... Hi, I'm plotting lines on a chart with a log x axis and linear y axis. The only way i seem to be able to get the chosen x axis labels to appear along the x-axis is by using a line graph. But if I use this I cannot change the x values for different data series as I can if I use a scatter graph (which only lets me label the log x-axis in factors of 10) I need the values: 31.5, 63, 125, 250.... displayed as the x-axis labels, but then need to add lines corresponding to a data series of 125, 250, 500.... but the x values can't be changed for individual data series. Is there a way round this problem? Many thanks Phil |
| 969 | I am wanting to add column A to column B - I know how to do that. But, I want to do each of 20 rows. I know I can but forgot how. Also, does my software come with a tutorial? I have Office xp for small business. Help! |
| 1124 | After doing an unsuccessful search, do you know where I can get an Excel tutorial? Regards, AC |
| 1127 | Hi Andie, what are you looking for? Maybe something like our tutorial? -center.com Ciao, Matthias "Andie" <andiecorbin@hotmail.com schrieb im Newsbeitrag news:139ea01c2204b$f9fba5d0$b1e62ecf@tkmsftngxa04... After doing an unsuccessful search, do you know where I can get an Excel tutorial? Regards, AC |
| 1128 | Andie, If you do a search on 'excel tutorial' you will find some ideas. / Or here is a list I have gathered. /Pages/Excel/homepage.html /view/cobrand/beginners/i/19 /excel/pivots.htm (on pivot tables) /dmcritchie/excel/excel.htm (go to the 'Excel Lessons & Tutorials' section) http://205.236.230.101/xl/ and some on VBA programming /trio/tut/excel/index.html 6.net/ /toc.htm /OzGrid.html /support/excel/content/vba101/default.asp /support/excel/content/Automation/automation.asp Andie <andiecorbin@hotmail.com wrote in message news:139ea01c2204b$f9fba5d0$b1e62ecf@tkmsftngxa04... After doing an unsuccessful search, do you know where I can get an Excel tutorial? Regards, AC |
| 1181 | try these urls "Andie" <andiecorbin@hotmail.com wrote in message news:139ea01c2204b$f9fba5d0$b1e62ecf@tkmsftngxa04... After doing an unsuccessful search, do you know where I can get an Excel tutorial? Regards, AC |
| 1183 | Hi Andie Just a note about the URL /OzGrid.html that is a very old one, the new address is -- \ Get 8 Add-ins in one! For less than the price of 1 /Services/AddinExamples.htm FREE EXCEL NEWSLETTER /News/2home.htm "Barbara wiseman" <b@nbpwiseman.fsnet.co.uk wrote in message news:OhVbDBFICHA.2312@tkmsftngp12... | Andie, | If you do a search on 'excel tutorial' you will find some ideas. | / | | Or here is a list I have gathered. | (go to the 'Excel Lessons & Tutorials' section) | and some on VBA programming | /trio/tut/excel/index.html | 6.net/ | /toc.htm | /OzGrid.html | /support/excel/content/vba101/default.asp | /support/excel/content/Automation/automation.asp | | | Andie <andiecorbin@hotmail.com wrote in message | After doing an unsuccessful search, do you know where I | can get an Excel tutorial? | | Regards, | AC | | |
| 1928 | Thank you. That is what I was looking for. :-) "hglamy" <Enterplan.de@gmx.net wrote in message news:#jNcDLFKCHA.608@tkmsftngp10... Fred, try using msagent technology. Regards, H.G. Lamy rag I am looking for information on how to make a tutorial in Excel using the animated assistants - such as the wizard. I remember doing this about a year ago and now I can not seem to find the information on how to do this, or remember what I did. Thank You Fred Zilz |
| 1932 | David Thanks for your input. I couldn't find where I wrote down Peter's website so I sent her the file. The website is a much better reference. Otto "" <dmcritchie@msn.com wrote in message news:umu3xgDKCHA.2660@tkmsftngp13... I think a link to Peter Noneley's website would be better especially if he updates. In any case a terrific easy to use reference. Excel Function Dictionary -- /noneley « by Peter Noneley, Alternative download site /peter.noneley workbook with 157+ sheets, each with an explanation and example of an Excel function. You might also take a look at my site in the area of /dmcritchie/excel/excel.htm#tutorials "Otto Moehrbach" <ottom@worldnet.att.net wrote in message news:OPdaFQDKCHA.1916@tkmsftngp11... Claudia I'm sending you, via email, a ZIP file of Peter Noneley's Excel Function Dictionary. It's an excellent piece of work. Otto "Claudia" <pena_c40@hotmail.com wrote in message news:16fe501c22826$2d22aa30$9be62ecf@tkmsftngxa03... Hello: Can anyone recommend a book that focuses on Excel worksheet functions? I have a basic knowledge of Excel but would like to learn more advance applications. Thanks! |
| 2083 | Does anyone know if there is an on-line tutorial for Excel? I only need to learn the basics. Thanks. -- Alexander Baron |
| 2111 | has a list of tutorials on his site: /dmcritchie/excel/excel.htm#tutorials Alexander Baron wrote: Does anyone know if there is an on-line tutorial for Excel? I only need to learn the basics. Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 2442 | I would imagine that if you gave the name for the Word XP document something similar might be found for Excel XP nearby. You can find some off-site tutorials on my excel.htm page mostly to university sites and oriented to students. Is there something of a particular nature that you want to see. Jumping into the middle of one ... Lesson 11: Creating a Custom Form /ExcelDev/Articles/sxs11pt2.htm or start at the beginning intro to lots of articles on Excel from the green bar at top of article. /exceldev/e-a&sa.htm HTH, , Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: /dmcritchie/excel/excel.htm Search Page: /dmcritchie/excel/search.htm "Lloyd H. London" <lhlondon@ix.netcom.com wrote in message news:3D34AC1E.9D77590B@ix.netcom.com... Microsoft has an excellent how to guide on its web site for new Word XP users, it is advertised for Legal users but applies to anyone. It can be down loaded by anyone who wants a copy. Does anyone know of a similar document for Excel XP, not necessarily at the Microsoft website? Thanks. |
| 2460 | Does anyone know of any good places online to get a good start on VB in Excel? I know that VB is the answer to some of the needs I have in Excel, but even if someone types out the code for me, I have no idea what I am supposed to do with it, or where to put it. I do not want to waste others' time with my ignorance. If it comes to it, I will buy a book. First, though, I thought I would ask here if there are any places for help,assistance for beginners,or even tutorials online. Thanks much, James |
| 2461 | James Start here for the basics. In no particular order. /support/excel/content/vba101/default.asp /dmcritchie/excel/getstarted.htm HTH Gord Dibben Excel MVP - XL97 SR2 On 16 Jul 2002 19:01:37 -0700, james31k@excite.com (James Tigert) wrote: Does anyone know of any good places online to get a good start on VB in Excel? I know that VB is the answer to some of the needs I have in Excel, but even if someone types out the code for me, I have no idea what I am supposed to do with it, or where to put it. I do not want to waste others' time with my ignorance. If it comes to it, I will buy a book. First, though, I thought I would ask here if there are any places for help,assistance for beginners,or even tutorials online. Thanks much, James |
| 2523 | A good source of VB code and how it is used is on a site written by Chip Pearson. Do an internet search for Chip Pearson Consulting Trev "James Tigert" <james31k@excite.com wrote in message news:fa1c54b4.0207161801.30850a54@posting.google.com... Does anyone know of any good places online to get a good start on VB in Excel? I know that VB is the answer to some of the needs I have in Excel, but even if someone types out the code for me, I have no idea what I am supposed to do with it, or where to put it. I do not want to waste others' time with my ignorance. If it comes to it, I will buy a book. First, though, I thought I would ask here if there are any places for help,assistance for beginners,or even tutorials online. Thanks much, James |
| 2876 | has a list of tutorials on his web site (scroll down to Excel Lessons & Tutorials) /dmcritchie/excel/excel.htm Emu wrote: Hi, Someone can suggest me where to find VBA training on line? TIA Emilio -- Debra Dalgleish Excel FAQ, Tips & Book List /tiptech.html |
| 3273 | try for tutorials ... - James Debra Dalgleish <dsd@contextures.com wrote in message news:<3D2EAEB5.5020909@contextures.com... has a list of tutorials on his site: /dmcritchie/excel/excel.htm#tutorials Alexander Baron wrote: Does anyone know if there is an on-line tutorial for Excel? I only need to learn the basics. Thanks. |
| 3823 | I am a University of Phoenix Online student writing a reflective paper based on an online tutorial for the Microsoft Excel spreadsheet application. I need to provide correct citation and reference, but cannot determine what city/state to use for Microsoft Corporation regarding the publication of Excel. In my reference so far I have: Microsoft Corporation (1999). Excel 2000. I need to list the publisher city and state and wasn't sure what to use. Thanks. |
| 3827 | Per www.switchboard.com White Pages: Microsoft Corp 1 Microsoft Way Redmond, WA 98052-8300 Phone:(425)882-8080 Categories: Computer Software | Importers | Computers-Manufacturers | Computer Peripherals (Manufacturers) | Computer Software-Manufacturers "Matt" <caden2001@hotmail.com wrote in message news:01b701c239c2$ae9bf410$2ae2c90a@phx.gbl... I am a University of Phoenix Online student writing a reflective paper based on an online tutorial for the Microsoft Excel spreadsheet application. I need to provide correct citation and reference, but cannot determine what city/state to use for Microsoft Corporation regarding the publication of Excel. In my reference so far I have: Microsoft Corporation (1999). Excel 2000. I need to list the publisher city and state and wasn't sure what to use. Thanks. |
| 3841 | The MS Excel technical office is in Texas. Although Joe is right, the big dogs are in Redmond.:) Adria "Matt" <caden2001@hotmail.com wrote in message news:01b701c239c2$ae9bf410$2ae2c90a@phx.gbl... I am a University of Phoenix Online student writing a reflective paper based on an online tutorial for the Microsoft Excel spreadsheet application. I need to provide correct citation and reference, but cannot determine what city/state to use for Microsoft Corporation regarding the publication of Excel. In my reference so far I have: Microsoft Corporation (1999). Excel 2000. I need to list the publisher city and state and wasn't sure what to use. Thanks. |
| 6137 | Taj, Select a row OR the ten rows with the white cross on the numbers or letters for columns (or column) then CTRL + "the plus sign" then F4 as many times as you wish Gilles Desjardins "TAJ Simmons" <awesome@NOMORESPAMpowerpointbackgrounds.com wrote in message news:uls6ZGnTCHA.2656@tkmsftngp11... Anyone know of a quick way to insert multiple rows in Excel XP/2002 ? Doing a "Insert" menu, "rows" takes for ages to insert 10 rows ;) Cheers TAJ Simmons microsoft powerpoint mvp awesome - powerpoint backgrounds, free sample templates, tutorials, hints and tips etc |
| 6148 | And if you're short on space on your toolbar, you can just add the add rows, add columns buttons. Then shift click will delete the row/column you have selected. Gord Dibben wrote: TAJ Right-click on ToolbarCustomizeCommandsInsert. Drag the insert row button to your Toolbar. Close. Select your range of cells in a column. Hit insert row button. Note there are buttons for delete row, insert and delete column. HTH Gord Dibben Excel MVP - XL97 SR2 On Wed, 28 Aug 2002 09:59:57 +0100, "TAJ Simmons" <awesome@NOMORESPAMpowerpointbackgrounds.com wrote: Anyone know of a quick way to insert multiple rows in Excel XP/2002 ? Doing a "Insert" menu, "rows" takes for ages to insert 10 rows ;) Cheers TAJ Simmons microsoft powerpoint mvp awesome - powerpoint backgrounds, free sample templates, tutorials, hints and tips etc -- Dave Peterson ec35720@msn.com |
| 6266 | Jim Excel 5.6 must be for the Mac(help me out here J.E). A brief history of Excel versions can be found at.... /history/sshistory.html Excel 97 is version 8.0 The following sites have tutorials online. /trio/tut/excel/index.html /toc.htm /el0.htm I am sure you could find a copy of Excel for Dummies out there somewhere. To learn "all about" Excel is a life's goal for some. You can easily learn the basics from these tutorials and practice, practice, practice. HTH Gord Dibben Excel MVP - XL97 SR2 On Thu, 29 Aug 2002 15:49:27 -0700, "James E. Colby" <TheColbyGroup@aol.com wrote: I have and use Windows 98SE on my system and it came loaded with Excel 5.6 Is Excel 5.6 also know as Excel 97? Some say its Excel 98, but I only have been able to find that name being used for those that own the Macs; which i do not use nor own. What course study would one of the many people out there recommend to me to learn all about Excel [5.6, 97 need to know which is which first off?] as quickly as possible? I need to learn this system ASAP; since my Fire Company will be using this accounting system, instead of the green analysis books that I'm comfortable with. I went looking for "Excel 97 for Dummies" and was told that it was out of print. Any ideas on this one? Any assistance you can provide would be greatly appreciated. Thank you. Jim Colby 08/29/30 |