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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Try the book:
Excel Programming for Dummies.
I found it great and easy to understand.

<dan@xxxxxxxxxxxxxxxx> wrote in message news:1189033767.123020.294510@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Positioning Pictures in a Worksheet
    ... Thanks much Jim for that additional piece of information and offering the ... As you seem to be getting the picture dumped on the sheet, ... (Excel Add-ins / Excel Programming) ...
    (microsoft.public.excel.programming)
  • Re: Positioning Pictures in a Worksheet
    ... As you seem to be getting the picture dumped on the sheet, ... The oRng cell has a Top and Left property that you can assign to the picture ... (Excel Add-ins / Excel Programming) ...
    (microsoft.public.excel.programming)
  • New to Excel programming
    ... I am working on a project where I need to do some Excel programming, ... It is possible to pass arguments by reference, ... It seems like it is not possible to add a user-defined type to a ...
    (microsoft.public.excel.programming)
  • Re: Cant see Trace Precidents sometimes.
    ... (Excel Add-ins / Excel Programming) ... When I had Windows 2000, Excel 2000 here at work and had no problems, ... and clip art (from computer or pictures of documents from scanner), ...
    (microsoft.public.excel.misc)
  • Re: New to Excel
    ... Have a look at excel programming. ... ZIP, Territory, ItemCode, SaleDate, Quantity and Price. ... sales performance over the past 6 months. ...
    (microsoft.public.dotnet.languages.vb)