Hi,
I need to write a macro which can select few number values in a field while opening a tab.
Can anyone plz help me with it?
Hi Subin,
This is for selecting entire field data:
Sub SelectALlFieldData
ActiveDocument.GetSheetObject("LB48").SelectAll
End Sub
This is for selecting some values of the object(listbox):
No need of macro for this
Trigger actions->select infield
FieldName='(value1|value2|value3value4)'
Hope it helps you
Regards..
Hi Subin,
This is for selecting entire field data:
Sub SelectALlFieldData
ActiveDocument.GetSheetObject("LB48").SelectAll
End Sub
This is for selecting some values of the object(listbox):
No need of macro for this
Trigger actions->select infield
FieldName='(value1|value2|value3value4)'
Hope it helps you
Regards..
Hi rav,
is it possible to do it with a macro?
Now we have direct option for it like select in field where you can give the options in the field you want it to be selected in the format FieldName='(value1|value2|value3|value4)'
Try avoiding macros as far as possible.