Program language loops

Reply #9

KnuckleHead — Wed, 23 Dec 2009 21:34:15 GMT

Afternoon all,

For anyone who's been reading this post, below is the code that works in Lotus 123. I'm sure it could be adjusted for Excel if needed.

Sub CheckCell_1(TargetRange As range, MatchCell As range, CopyCell As range, rows As Long, Where As Variant)

'Check for a number in a range, then move up or down and insert a value

'or colorize. MatchCell and CopyCell must be single-cell ranges.

'

' Place this script by itself in the Globals section.

' Place this line in the ac... [ More ]

Reply #8

time*treat — Thu, 17 Dec 2009 23:32:42 GMT

There's plenty of free info on the web, if you prefer that over books.

With the possible exception of OpenOffice, I think for older languages / app versions, books are the way to go.

Reference books that are a few versions out-of-date can be had for way cheap.

You can build a small library of older books (with plenty of still-usable info*) for less that what one of them cost when new.

*Loop and branching syntax are pretty much the same in version_now as they were in version_1 of wha... [ More ]

Reply #7

KnuckleHead — Mon, 14 Dec 2009 17:57:37 GMT

Morning RJOh time*treat,

RJOh, as to your suggestion about paper and pencil, I comprehend that very well. I already have what I want to do figured out. Just not the how to in computer language. I'm lacking very badly in the computer language comprehending department. Generally, if I can't record what I want the program to do, I'm lost trying to figure it out.

time*treat, great site. I had not discovered that site before. Thank you. Weeks appears to do everything in macros, and I think that... [ More ]

Reply #6

time*treat — Mon, 14 Dec 2009 02:12:19 GMT

OK, you're looking for the Lotus version of a for-next loop, simply called a for loop, in Lotus.

Do a search engine lookup of Lotus 123 macros, hit the 'lynnbob' page/link.

At 7.4 {For}, they provide

{for counter-location,start-number,stop-number,step-number,starting-location}

Bookmark/save/printout that page. Lots of other good info there.

Also, you'll need the {If} command. It's there, too.

Reply #5

RJOh — Mon, 14 Dec 2009 01:13:03 GMT

Yes, but how would you do it if you only had paper and pencil. I program using GWBasic and many times when I want to program a routine I first do it using paper and pencil recording each step (flow chart). Once I understand what I need and what I have to do, programming it is easier. Also explaining it to others is easier too.

Reply #4

KnuckleHead — Sun, 13 Dec 2009 23:40:40 GMT

Evening RJOh,

I know what I want it to do, but not how to tell it what to do. Does that make sense

Reply #3

RJOh — Sun, 13 Dec 2009 22:39:26 GMT

Generally speaking a programmer can't program a computer to do a task he doesn't understand how to do himself. First figure out what you would have to do to accomplish the task and then it will be easier to write a set of instructions for the computer to do the same.

Reply #2

KnuckleHead — Sun, 13 Dec 2009 20:52:32 GMT

Afternoon time*treat,

Sorry about that, I'm using Lotus 123 script which is very simular to Excel VBA.

I haven't been able to figure out how to construct the loops that tell the computer what to look for and do. Since I don't have a lot of experience in computer lanuage, my understanding of what is needed is probably incorrect.

Below is what I have so far. (I haven't been able to figure out how to post a screen shot here for visual understanding along with the script, if I could I would... [ More ]

Reply #1

time*treat — Sun, 13 Dec 2009 06:52:21 GMT

You may get useful replies if you specify the application/language you are programming in and where you are trying to pull the draw data from.

Program language loops

KnuckleHead — Sat, 12 Dec 2009 21:45:30 GMT

Afternoon all,

I'm trying to automate my files to automaticly enter the current draw data, but I'm now at the point that I don't understand how to create the logic loops for the language. Does anyone out there understand how to create program language loops?

Once I can see an example of how they'er desgined, I can normally figure em out and then modify them to work.

Can anyone assist? If so, I can attempt to post examples here...

Thanks ahead of time for any interest.... [ More ]