Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to macro and i'm using input box for get values for variable.
i want to reset input value.
please help me to do that.
can't you use a sheet level trigger instead of a macro?
i don't know how to do that, could you please explain it
Using button trigger. See attached qvw.
Hi anu ,
Try some thing like below
sub clear
set v = ActiveDocument.Variables("Variable1")
prop = v.GetProperties
dim list
list=Array("abc","45","xyz","")
prop.PreDefinedList = list
v.SetProperties prop
set ClearAllib = ActiveDocument.GetSheetObject("IB10")
ClearAllib.SetVariableContent 0,"",true
Erase list
list=Array("abc","45","xyz")
prop.PreDefinedList = list
v.SetProperties prop
end sub
if this pop up macro edit window.
i have a feild called sales and need to clear that feild,
Sub Clear
ActiveDocument.Fields("FieldName").Clear
End Sub
but this doesn't work. please help me