Does the following statement make sense?
When a macro is named with the same name as an internal command, the macro runs in place of the command.
Does the following statement make sense?
When a macro is named with the same name as an internal command, the macro runs in place of the command.
~Anne Troy
I think so.
Best Regards,
Carlos Paleo.
To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.
If Debugging is harder than writing a program and your code is as good as you can possibly make
it, then by definition you're not smart enough to debug it.
http://www.mugrs.org
It makes sense in Word but the same facility is not in other Office programs - least I couldn't swear for all of them but I think it's only Word.When a macro is named with the same name as an internal command, the macro runs in place of the command.
Enjoy,
Tony
---------------------------------------------------------------
Give a man a fish and he'll eat for a day.
Teach him how to fish and he'll sit in a boat and drink beer all day.
I'm (slowly) building my own site: www.WordArticles.com
Thanks, Tony.
Another question....
I have private sub and public sub.
I have function.
WTF is Type??
~Anne Troy
Anne,
I would not say you were obligated to describe IF statements in the same topic as WITH statements. Two very seperate and different methods. Or did I miss something? (Just found this thread.)
Re: Ken's file, I need to get it up. Did you take a look at it Anne? Is it helping?
I believe this will give you an error in Excel, at least it does for me. You should get a compile error that says, "Expected identifier."When a macro is named with the same name as an internal command, the macro runs in place of the command.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
I'm not using the file. I'm simply providing a link to it.
I've decided to scratch specific references to with and ifs and such in each of the procedures we're providing. BUT, I am gonna provide a brief description of those kinds of statements.
In other words, I was gonna say "the following procedure uses blah blah; refer to the appendix". I've decided to just say in the beginning something like "for a brief explanation on many of the ...., see the appendix."
~Anne Troy
If I'm following this, Type is basically a definition of a Data Structure.
Say you are working with information about a person. You could have lots of variables - name, age, email addy, inside leg, whatever. Or you could declare a Type:
[VBA]Type PersonDetails
Name as String
Age As Long ' To allow for modern miracles
EMail as String
InsideLeg as Integer
End Type
[/VBA]
and then you could declare a variable of that Type instead of one of the built in types:
[VBA]Dim Tony as PersonDetails[/VBA]
and you would have access to all of the details in a kind of obvious way:
[VBA]Tony.Name = "Tony"
Tony.Age = 52[/VBA] etc.
or you could have an array of friends and want the same info on all of them:
[VBA]Dim Friend(1 to 100) as PersonDetails
Friend(1).Name = "Anne"
Friend(2).Name = "Annie"
Friend(3).Name = "Dreamboat"[/VBA]
I could go on ... :rofl
Enjoy,
Tony
---------------------------------------------------------------
Give a man a fish and he'll eat for a day.
Teach him how to fish and he'll sit in a boat and drink beer all day.
I'm (slowly) building my own site: www.WordArticles.com
I see that EYE am not in that list of friends??
What's up with that!!!???
Thanks!!
~Anne Troy
Anne, I noticed that he didn't put the End Sub line in... maybe you're the first one off the screen.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
There! I fixed his code!
~Anne Troy
And here you say you know nothing about VBA!
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
You see, you DO know code
I was writing code for you - and I just guessed that you might have some friends with those names. You can use your real friends if you like.
Enjoy,
Tony
---------------------------------------------------------------
Give a man a fish and he'll eat for a day.
Teach him how to fish and he'll sit in a boat and drink beer all day.
I'm (slowly) building my own site: www.WordArticles.com