for each exchange to while

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,

i need to exchange
For Each varItem In .ItemsSelected
varitem is a varient type
to a while sentence
does anyone have an idea
 
Why? As in why do you need a While loop instead of a For Each loop?
 
i have list control
if there are items picked.,the query will use them as a filter if not
it will not run a loop but just will build global query
for now i can only use picked items otherwise it will not make the
global query
do you have any idea for the logic?

Baz כתב:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

refer to second column of listbox 7
Problem with Items Selected from List Box 2
Multi Value list box selects all customer 1
VBA-- Open a Form with filter accoding to LISTBOX multiple choices 3
Run select query from VBA code where criteria comes from a multi select ListBox 2
help Output to PDF for selected value 3
Listbox 3
SQL String Help 6

Back
Top