Old Aussie needs Help with starting VBA

[thebigkangaroo]

Hi y’all.

I must first tell you that I and from Australia, 49 years old (and feel every year of it!).

I have very little programming experience but what I remember is that you have a list of commands/functions, when organised into a specific format (ie COBOL) and with the correct syntax, you have an action performed.

I have purchased the John Walkenbach Power Programming with VBA 1000 page book and I don’t know if I am coming or going. If I read the book 10 times front to back I may get somewhere but I would be dead from old age!! What I think I need is a list of commands/functions, in editable (WORD) format so I can use my own examples to understand what each command does etc and some rules about the structure and syntax of the application. Then you go about putting it all together to do little “things” until you learn enough to combine several “little things” to produce a useful program.

Questions for you modern guru’s:

1. Does anyone know where I can get an editable (prefer WORD) list of commands/functions for VBA?
2. Does anyone have any tips for an approach to take to learn VBA sufficiently to be able to develop useful programs for my own use. My brain unfortunately is not a sharp as it used to be

Thankyou very much in anticipation.

Kind Regards

Darren

 

[thebigkangaroo]

G'day Chuckles. No I mean temps in the single figures. The problem here is that I went fishing in my boat 4 days ago and go sun burnt to the extent my nose is peeling. The next day, you almost get frost bite (a bit of exaggeration!) You quoting euros indicates you are a European (Wow...I am not as dumb as I thought I was). My wife is from the UK and I know how bloody cold it gets over there. And again...very good advice Chuckles.

We all have are far more serious issue to deal with...finding out how old Venkat1926 is !!! He has set the challenge...united...we will conquer!!!!
Venkat...a clue would be nice

 

[Michael M]

Geez, Darren...it didn't take you long to fit into the parry and thrust of MrExcel.
Fishing...urgh !!!
Golf is the way to go.
BTW, have you visited the Lounge here yet ?? It gets evern better in there !!

 

[chuckchuckit]

We all have are far more serious issue to deal with...finding out how old Venkat1926 is !!! He has set the challenge...united...we will conquer!!!!
Venkat...a clue would be nice

Hmmm....

Sub MaxAgeSearch ()
   Dim Venkat1926age as Long
   Dim VeryOld as Integer
 
   If 2011 - Venkat1926 > 250 Then
      VeryOld = 1
      Exit Sub
   Else
      VeryOld = 0
   End If
End Sub

Can't seem to find a value for Venkat1926age.... Maybe it needs to be a Double instead of a Long?

So far that is the best code I can come up trying to figure this delema out...

Chuck

 

[Michael M]

Hmm, maybe 1926 is significant in Venkats age.

 

[chuckchuckit]

Hmm, maybe 1926 is significant in Venkats age.

Hmmm... if you are saying what I think you are saying, some people might say that is kinda old.

Heck, most people's Grandparents aren't even that old.

Shocking...

Guess that means most of us here might still have some moons left of coding in us too! Must still be hope for the rest of us then.

P.S. (All meant in fun, of course).

 

[venkat1926]

QUOTE

If 2011 - Venkat1926 > 250 Then
UNQUOTE
"venkat1926" is not a number so cannot be "long". it is a string.
you cannot subtract a strings from a number.
</pre>

 

[chuckchuckit]

QUOTE

If 2011 - Venkat1926 > 250 Then
UNQUOTE
"venkat1926" is not a number so cannot be "long". it is a string.
you cannot subtract a strings from a number.

No wonder that code did not work right. Hmm...

Could we get an other clue perhaps? Or maybe we could ask some questions.?

 

[chuckchuckit]

Kidding aside. I Hope to be still coding as long as many here have been. Something to look forward to.

venkat1926, I was wondering how long you have been VBA coding?

 

[venkat1926]

see the join date. Learning process couple of years before that. Of course even now I am on learning curve. Not that I want to be mysterious.

 

[chuckchuckit]

I hope I would be actively coding at the same age. Code some for my work, and for the enjoyment. Bit less than a year now VBA since quit 'C' programming 20 years ago due to bad carpel tunnel back then. Never ending learning curve I am thinking...

Coding can be very creative. Reminds me of writing music in some ways. Uses same part of the brain perhaps.