Infinite while loop in VBA

Question

Can anyone see whats wrong with my while loop below? Basically I want to request a user to enter either "m" or "w", however, when I run it seems to enter an infinite loop despite the user entering "m" or "w".

While period <> "m" Or period <> "w"
    period = InputBox(Prompt:="Please enter the period (m/w): ", Title:="Period")
Wend

Thanks Kevin and Daniel, AND worked perfectly :D

SeekingAlpha
– SeekingAlpha

2013-12-18 21:40:22 +00:00
Commented Dec 18, 2013 at 21:40 — SeekingAlpha
– SeekingAlpha, Commented Dec 18, 2013 at 21:40

Daniel · Accepted Answer · 2013-12-18 21:30:12Z

3

It is an infinite loop because if period = "m" then period <> "w" and vice versa

Switching to the following is likely what you want.

While period <> "m" AND period <> "w"
    period = InputBox(Prompt:="Please enter the period (m/w): ", Title:="Period")
Wend

answered Dec 18, 2013 at 21:30

Daniel

13.1k3 gold badges39 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kevin DiTraglia · Accepted Answer · 2013-12-18 21:29:55Z

2

I think you mean And instead of Or pretty much any input will not be 'w' or 'm' including w and m. (w is not equal to m so that conditional is still true and vice versa).

answered Dec 18, 2013 at 21:29

Kevin DiTraglia

26.2k20 gold badges95 silver badges145 bronze badges

Collectives™ on Stack Overflow

Infinite while loop in VBA

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related