What is the difference between for..if, case statements, do..while?

I'm using Excel 2000 on Windows 2000 professional.


I've been employed since February to provide solutions in Excel and
Access 2000. I've been successful finding examples in the newsgroups
and revising them to my projects.

However, I have a big knowledge gap and I'm requesting your direction.

How does one decide which programming construct to use.

Are there some questions I could answer that would help me determine
when to use:

With
if
For..if
Do..While
Case

I also would like to learn the proper syntax for these constructs.

I've purchased John Walkenbach's "MIcrosoft Excel 2000 Bible, and Ken
Getz's "Access 2000 Developer's Handbook", but I am still not clear on
these concepts.

Is there anyone that would direct me to learning source?

Thanks,

Dan Dungan

.

Relevant Pages

  • Re: What is the difference between for..if, case statements, do..while?
    ... Excel Programming for Dummies. ... I'm using Excel 2000 on Windows 2000 professional. ... How does one decide which programming construct to use. ...
    (microsoft.public.excel.programming)
  • Re: truncating text fields
    ... Because of customer requirements, I'm constrained to version 7, which doesn't seem to support direct import/export between FM and Excel. ... I found that Windows FM had many UI anomalies and non-standard interfaces that don't exist in other Windows programs. ... I spent the same amount of time unsuccessfully trying to generate properly formatted labels in FM as I did coming up with a successful solution through the export method, although for a more experienced developer, the converse would probably be true. ... It will even do some basic formatting so that the Excel cells resemble the data in FileMaker. ...
    (comp.databases.filemaker)
  • My apologies, I did not mean that to you,at all.
    ... I have word and excel in multiple separate windows which allow me to resize ... Why we would need Powerpoint in separate instances are for the same reason. ...
    (microsoft.public.excel.setup)
  • RE: Excel 2003: Not enough system resources to display completely
    ... I'm not sure if the message occurs when starting Excel with /s switch. ... Click the Services tab, click to check the "Hide All Microsoft Services" ... 281770 How to perform clean-boot troubleshooting for Windows 2000 ... we need to start Windows under safe mode to test. ...
    (microsoft.public.excel.setup)
  • Re: X Box 360? errrrrr no thanks
    ... Windows is quite simply the best tool for the job. ... What does Excel have to do with Windows? ... Is it shoddy simply because it doesn`t meet the needs ... doesn`t meet my neighbours need to transport his large family round in ...
    (uk.games.video.playstation)
Loading