Store list box selection in a variable

[pkelly]

I have a list box and I would like to store the selected value(s) is a variable.

I think I have worked out how to get the value from the list box - "ProdFamily" is my list box field.

set prodfamilyselection=ActiveDocument.Fields("ProdFamily").GetSelectedValues

How do I store this in a variable?

[#2 · Accepted solution]

Hi,

here you are

sub StoreValues

set v = ActiveDocument.Variables("sel")
set doc = ActiveDocument
set mySelections = doc.fields("SW_Temp").GetSelectedValues
sel = chr(39) & mySelections.Item(0).text & chr(39)
for i = 1 to mySelections.Count - 1
sel = sel & chr(44) & chr(39) & mySelections.Item(i).text &chr(39)
next
v.SetContent sel,true

end sub

A QV example follows in a few minutes.

Rainer

[#3]

Hi,

here are the application.

It´s not 100% perfect.

Rainer

[pkelly]

Thanks Rainer - this is excellent and is exactly what I am looking for...

One quick question - in your example, how do you get the "sel" variable to update automatically when a list box selection is made?

[#5]

Please remove the second macro.

Than the application runs without problems.

Rainer

[#6]

Document Properties => Macros

See the screenshot.

Rainer

[pkelly]

Thanks Rainer ... Your solution is exactly what I am looking for...

[#8]

Thanks Rainer.... its really good one ...

Once again Thanks

[#9]

I am using latest personal edition . I dont see macros Tab in Document properties. Could you help? Again my macros also dont recognize ActiveDocument Object