Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-11-08 09:52 AM

VB Macro to select field values in listbox which does not have Object Name

Hi,

Need help on the macro!!

I have listbox where for field selection, Expression is set... hence we dont have field name to select values in Macro. Can anyone help me in fixing this.

To breif in detail macro what I used to select field values

ActiveDocument.Fields("SECTO.LB_SECTEUR",objSheet.Cells(i,18)).select TerrC.Item(h).Text

Now need to refer Object ID, since in listbox field has set to expression

Like ActiveDocument.Fields("OBJECT_ID",objSheet.Cells(i,18)).select TerrC.Item(h).Text

Can anyone provide me the syntax.

Thanks a lot in Advance!!

Regards,

Preethi

405 Views
0 Likes
0 Replies