Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want to learn macros in excel
hi everyone,
I'm really intrested in learing how to use macros. Anyone who can provide a link where i can learn using macros in excel step by step? Or perhaps documents i can refer to? I do have bit of knwledge bout VB programming, however when i try checking out if i can do macros....hehehehe i failed, it's quite hard to refer to the cells, or sheets or even obtaining the value of a certain cell. The properties pane is so limited. Unlike with having a form in VB, all the objects are there, all you need to do is name them and you can easily program events and what not. I do hope someone can help me. Thanks, melmac -- "excel newbie" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want to learn macros in excel
Hi Melmac,
As a starting point, David McRitchie lists resources at: Visual Basic for Applications ( VBA ) materials (#vbatutorials) http://www.mvps.org/dmcritchie/excel....htm#tutorials Whilst on the site, try wandering - you should find vast quantities of interesting material! --- Regards. Norman "melmac" wrote in message ... hi everyone, I'm really intrested in learing how to use macros. Anyone who can provide a link where i can learn using macros in excel step by step? Or perhaps documents i can refer to? I do have bit of knwledge bout VB programming, however when i try checking out if i can do macros....hehehehe i failed, it's quite hard to refer to the cells, or sheets or even obtaining the value of a certain cell. The properties pane is so limited. Unlike with having a form in VB, all the objects are there, all you need to do is name them and you can easily program events and what not. I do hope someone can help me. Thanks, melmac -- "excel newbie" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want to learn macros in excel
Hi,
I'm replying because I was in this situation a year ago (and am still learning). There's loads of ways to learn, plenty of resource on the internet but my start point would be to buy a book (or many books like I did - try amazon). They'll become a great reference point later on too. Also VB help in Excel is a good reference point too. Most of all don't give up! I had many frustrations when the simplest things took hours to code simply because I didn't know how to refer to an object / range / variable etc. However practise makes perfect, so good luck! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want to learn macros in excel
See David McRitchie's "getting started with VBA and macros" site.
http://www.mvps.org/dmcritchie/excel/getstarted.htm Don't forget the Macro Recorder which most times gives you an idea of what has to be done. Tweaking of the recorded code is necessary in some cases. Tushar Mehta has a tutorial on tweaking recorder-generated code. http://www.tushar-mehta.com/excel/vb...rder/index.htm Gord Dibben MS Excel MVP On Fri, 9 May 2008 22:00:00 -0700, melmac wrote: hi everyone, I'm really intrested in learing how to use macros. Anyone who can provide a link where i can learn using macros in excel step by step? Or perhaps documents i can refer to? I do have bit of knwledge bout VB programming, however when i try checking out if i can do macros....hehehehe i failed, it's quite hard to refer to the cells, or sheets or even obtaining the value of a certain cell. The properties pane is so limited. Unlike with having a form in VB, all the objects are there, all you need to do is name them and you can easily program events and what not. I do hope someone can help me. Thanks, melmac |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want to learn macros in excel
refer to Ron's site. This should help too http://www.rondebruin.nl/fso.htm
"melmac" wrote: hi everyone, I'm really intrested in learing how to use macros. Anyone who can provide a link where i can learn using macros in excel step by step? Or perhaps documents i can refer to? I do have bit of knwledge bout VB programming, however when i try checking out if i can do macros....hehehehe i failed, it's quite hard to refer to the cells, or sheets or even obtaining the value of a certain cell. The properties pane is so limited. Unlike with having a form in VB, all the objects are there, all you need to do is name them and you can easily program events and what not. I do hope someone can help me. Thanks, melmac -- "excel newbie" |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want to learn macros in excel
Thanks to you all!!!! Great help! Norman,Anon,Gord,Yossy...many thanks! ;-)
-- "excel newbie" "Yossy" wrote: refer to Ron's site. This should help too http://www.rondebruin.nl/fso.htm "melmac" wrote: hi everyone, I'm really intrested in learing how to use macros. Anyone who can provide a link where i can learn using macros in excel step by step? Or perhaps documents i can refer to? I do have bit of knwledge bout VB programming, however when i try checking out if i can do macros....hehehehe i failed, it's quite hard to refer to the cells, or sheets or even obtaining the value of a certain cell. The properties pane is so limited. Unlike with having a form in VB, all the objects are there, all you need to do is name them and you can easily program events and what not. I do hope someone can help me. Thanks, melmac -- "excel newbie" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i learn to write excel macros? | Excel Programming | |||
Best way to learn/use macros? | Excel Discussion (Misc queries) | |||
I want to learn Macros in excel, please let me know about it | New Users to Excel | |||
What's the best way to learn Pivot Tables and using Macros in Exc. | New Users to Excel | |||
Best place to learn about macros | Excel Programming |