How can I loop this Select statement?

**RynMan** · 02-24-2009, 01:00 AM

Heya guys

I have values in column A, and I'd like to have these values run through a formula that I've pre-determined using a Select Case statement, and display the corresponding value in Column B. I just don't know how I can do it. I didn't want to write a massive IF function, so opted for VBA.

My code for the Select Statement (which works great, I just need to loop)...

Please Login or Register  to view this content.

**shg** · 02-24-2009, 01:21 AM

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with Code Tags.

**RynMan** · 02-24-2009, 10:53 PM

My apologies - that's much better.

**mewingkitty** · 02-24-2009, 10:57 PM

Need to loop how much?
Like....

Please Login or Register  to view this content.

?

**RynMan** · 02-24-2009, 11:20 PM

Originally Posted by mewingkitty

Need to loop how much?
Like....

Please Login or Register  to view this content.

?

Yeah basically til it reaches an empty cell. Would that work?

**mewingkitty** · 02-24-2009, 11:56 PM

Yup, that it will.

do until <condition>

loop

is handy, just don't forget to add a + to your integer once for each loop, otherwise you sit there like me, staring blankly at the screen, wondering why it's frozen and not moving past the first cell

IE

Please Login or Register  to view this content.

will show message boxes 1, 2, 3 etc. up UNTIL x = 5.
once x = 5, it will drop the loop, so you'll only get a msgbox up to 4.
If you're like me and you still forget to put in the x = x + 1, you just get msgboxes 1, 1, 1, 1, 1, 1, and then you start to figure it out :P

**mudraker** · 02-25-2009, 01:50 AM

heres another method
Assumes data starts in A1

Please Login or Register  to view this content.

**maya** · 02-25-2009, 04:01 AM

i have a problem to separate data.argon 10,oxygen 19,oxygen 20. this data,is view in excell.i import this data to access 2003,then i must separate that using looping.i want from this data become in 2 places in database. like,
textbox type=argon,oxygen,oxygen
textbox quantity=10,19,20
could you all help me and show the example coding?

**mudraker** · 02-25-2009, 06:31 AM

maya

Welcome to Exceltip forum

Please take a couple of minutes and read ALL the Forum Rules

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.