VBA, search and return a message

**hluk** · 07-14-2008, 01:27 PM

Thanks for the prompt reply. I tried to add a 3rd condition to the script and it didn't turn out too well.

So, from what I understand, the for loop tries to find the Arr(0) first. Then if Rng isn't empty, it will put value into cell B4. Then it tries Arr(1). However, now I need a third condition, a case where both "normal termination" and "error termination" aren't found.

Is this what I should add? If so, where should I add this?

PHP Code:


Else

            .Range("B4").Value = "This analysis was not completed/ interrupted.  Please rerun or discard."

**VBA Noob** · 07-14-2008, 01:32 PM

Arr = Array("N o r m a l    t e r m i n a t i o n", "E r r o r   t e r m i n a t i o n")

The i statement loops throught the two conditions above (0 = Normal and 1= Error). If it finds both it will accept the last one.

If none found I would use the Else statement for that.

As you are finding out you need to spend more time thinking about all the options before posting a question

VBA Noob

VBA, search and return a message

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions