Current selections in text box without x of x or ALL

[Johnnyg248]

I think the Current Selections box is very slick

however, the problem I have is that if there are a large amount of data in a list box and multiple selections are made the actual values are not shown.  Just get a 5 of 9 selected.

Similarly, if all the selections are chosen,  the word all is displayed

I was thinking of populating the current selections into a list box

I have done a fair amount of searching and I see that a number of responses say to use GetCurrentSelections

I know GetCurrentSelections has a number of arguments as shown below

GetCurrentSelections([record_sep[,tag_sep[,value_sep [,max_values [,state_name]]]]])

I just haven't been able to find any helpful examples of how the arguments can be used.

I seem to keep finding the generic  GetCurrentSelections()

Is there some combination of arguments that will show the actual values  for all fields instead of 5 of 9 or ALL ?

I know there is  getfieldselections

However there are a number of fields that can be selected  with only a few that are at any given time so it would be a bit tedious to account for all the fields that could possibly be selected individually

I would like to avoid this if possible.

I realize someone is probably saying to themselves "what is the big deal ?"  "all the fields are on the sheet"

This is indeed an excellent question 🙂

The reason I would like selections consolidated in a list box is that I have figured out a way to export different sheet

objects into excel with each sheet object going into its own worksheet

So I would like to be able to have the selections list box in one worksheet and the resulting straight table in another

Hopefully, this makes sense!

I am happy to share the resulting qvw when I get all the different parts working together

Thanks!

[chrismarlow · Accepted solution]

Hi,

I don't know if there is a point at which this fails but you can set the 4th parameter, max_values, to a large number & then you don't get the ALL/ X of Y, so here at 1000;

=GetCurrentSelections(chr(13),':',',',1000)

Cheers,

Chris.

[Johnnyg248]

Thanks Chris

Exactly what I was looking for!