Quin,

Thanks for your reply.

1. I understand that you find it straight forward to use Goto, but when you
start writing larger applications, you will find it harder to follow the
structure in the code, specially if your code need more than one goto
statement. I only use goto statements in error handling situations.

2. '<' (not equal to) is the opposite of '=' (equal to). So if the cell
tested is not empty, then proceed with next statement, else goto end if
statement.

3. Glad you figured out why I inserted the Trim statement.

4. The textbox margin section is commented out, because they are only needed
if you want to change default settings.

I hope this answered the questions.

Per

"Quin" skrev i meddelelsen
...
Mike H,

Thanks for fixing my code. I can see how the €œRange€� statement can be
used
to accomplish my task. The result is exactly what I needed and wanted.


Jessen,

I found a lot of interesting information in your reply, but since I am
learning, I also have several questions. I hope you have a minute to
answer.


1. I dont understand why it is frowned upon to use goto statements. It
seems like such an easy and straight forward thing to do.
2. I cant get my mind around using a < symbol. I tried to Google it
with
no success.
3. I Googled €œTrim€� to find it removes leading and trailing spaces but not
sure why that helps in this case.
4. Im not sure why the text frame section is commented. Is that just to
use default settings when the text boxes are created?

My last observation is €œI must be Dyslexic€� Very poor of me to not notice
my
confusion on the use of the €œCells€� statement. I appreciate your comment
to
direct my attention to it.
Thank you Mike and Jessen

Quin