Posted on 06/16/2017 6:48:23 PM PDT by RoosterRedux
I have been learning VBA for Excel for a few weeks. Have used Excel for years (I am an adept mathematician) but haven't taken the time to learn the language which supports it.
I have been searching videos that teach this subject and, so far, this is the best I have found.
I welcome advice from Freepers who know better than me.
My professional career grew up in the period prior to excel, but not prior to computers.
If I had Excel in grad school, I would still be in the basement running numbers.
$10 or $20 grand for a few weeks work. Can now be done on Excel with VBA...or so I think.
Google “why not to use Excel for statistics” (assuming you are an academic, it’s OK for business).
I am a contributor to a site called excel forum. A lot of knowledgeable people there and even though I’m listed as a forum expert i learn a lot from the other contributors. Stop by the site if you haven’t seen it already. They have tutorials and a VBA section.
“I welcome advice from Freepers who know better than me.”
What type of advice do you want?
I was self taught years ago in my programming days. I also used the excel forum mentioned by one Freeper, which was very helpful. In general, I would record steps and then read the code it generated. I also googled ‘loops’ and other common programming techniques to understand the language. If you already understand programming logic, you can ascertain the language with forums and using the record function. Good luck!
Excel was the “killer app” that made me buy a home PC in 1992.
Excel is very good with integers. Not so much with fractions....
I cut my teeth on DigiCalc which only ran on VAX/VMS. It had dimensions before dimensions were cool.
I did this a couple decades ago, but it is Visual Basic and you can record what you do so it writes it’s own code. Then you can go back in and edit it.
I am a VBA guru. Folks at work think I’m a magician. It’s good stuff.
“Excel was the killer app that made me buy a home PC in 1992.”
Lotus 1-2-3 was the killer app that made me buy a PC in 1983.
“Not so much with fractions....”
What do you mean?
Resolution problems with small fractional values.
If you’re serious about that (statistical analysis) you use Minitab plugin for Excel.
“Resolution problems with small fractional values.”
I really don’t work with very small fractional values. How small are you referring to?
Stuff close to zer0. I was constructing a 1D time based vehicle braking model and got “ringing”, likely associated with subtracting small values from each other where the sign got screwed up because the resolution was not enough.
” I was constructing a 1D time based vehicle braking model “
I have to ask ... why were you using fractions?
” I was constructing a 1D time based vehicle braking model “
I have to ask ... why were you using fractions?
Actually decimal values < 1 .
Fractions = decimal values with significant digits < 1 .
Numbers are fungible.
Excel was not the proper choice for my model, but excel was my known hammer to use to try to pound my nail down.
It worked well, but there were issues I couldn’texplain at the time. Now I know better..
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.