Reset input Box values using Macro

[anuradhaa]

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.

[#2]

can't you use a sheet level trigger instead of a macro?

[anuradhaa]

i don't know how to do that, could you please explain it

[tresesco]

Using button trigger. See attached qvw.

[sasikanth]

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

[anuradhaa]

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