Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
Thanks Chris
Exactly what I was looking for!