i seek code for an undefined problem (-:

[Emeroogork]

I teach MS Office at the University. The issue is that most students already know Office but it is a required course (Go figure...) By bringing in VBA, I can improve the experience. I also teach VB in another course and I can introduce them to using the language in Office there too.

I would like code for problems to solve in Word, Excel, PowerPoint, and Access. The problems have not been defined.

I am wondering issues have been brought forth here and solved that I may use them to develop lessons.

Thoughts appreciated....

[TysonLPrice]

You might be better served asking the moderators to move this to the Office Development forum.

http://www.vbforums.com/forumdisplay...ce-Development

[Emeroogork]

Better yet, I see a huge selection of problems from which to select right there without posting my request (-:

I see no indicator to mark this as resolved....

Thanks...
P.S., I just stole your line about recursion.

----------------------------------------------
The problem with living the Antarctic is that your pens and pencils fall out of your shirt pocket.

[TysonLPrice]

I see you don't have that many posts. If you are done with this thread go up to thread tools and mark this resolved. That way people won't open it trying to help.

[boops boops]

I see no indicator to mark this as resolved....

If you are the thread starter, you will see an option for "mark thread resolved" in the Thread Tools menu at the top of the thread display. Furthermore, if you haven't already rated Tyson, I think he deserves a positive rating from you (star icon). Particularly since you have stolen his signature motto.

edit: oops, I always take too long ...

BB

[Emeroogork]

I did send credit and also offered a motto in return.

I went to the suggested location and found 3 projects where I need at least a dozen. That location had only 2 pages. Can anyone suggest other places for me?

These need to be simple and attractive problems as these are mostly first year programmers. One that I did find was to have a cell flash colors relative to the value placed. Maybe I won't mark this as resolved just yet.

Now that I know more of what I want, if I reword the request, is it kosher to post it again in the Office section?

[ident]

What university do you teach at? Interested.

[Shaggy Hiker]

I applaud your approach to the teaching.

The forum in question only shows the threads in the last month by default. That doesn't mean that there are only two pages, just that the forum isn't as frantically active as this one is. There are FAR more threads than that. At the bottom of the forum there are some drop down combos in the Thread Display Options section. When I changed the drop down for Show Threads from the... to Last 100 days, I ended up with 6 pages. You can choose an even longer interval to get even more.

[Emeroogork]

oop, silly me for thinking that there were only two pages. I just saw that in the last 100 days are 214 pages! What a gold mine for teaching tools.....

[Shaggy Hiker]

Well, the gold is there, but not everybody knows how to extract it. Happy hunting.

[Emeroogork]

ow I am thinking that I might set students free in this forum to seek their own projects, follow discussion and eventually participate.

I might be asking too much there,,, they are only first year students....

[Shaggy Hiker]

We've seen worse. Just teach them how to use debugging tools like breakpoints and code stepping and they'll be way ahead.

[jayinthe813]

That is really good in my opinion. I took a Excel class with a small VBA portion that never solved real-world problems and it didn't really help much later on.

[Españolita]

I might be asking too much there,,, they are only first year students....

It is not possible to ask too much! In a previous job, I was asked to put systems in place for a factory and not given any tools to do so. I did the whole exercise in VBA and in the end it tracked goods through the factory, helped in giving estimates, improved efficiency, dealt with goods in and out and did invoicing. All this in EXCEL! The point here was ...... I had to learn VBA as I was doing it. It was an incredible experience.
In my signature, you will see a link to a game I made in Excel, Re Si's comments, you can clearly see that that was also written during the learning process.