Assigning an expression value to a variabe in macros

[#1]

HI

I am having a problem in Assigning an expression value to a variabe in macros..

This is my script

Sub ShowPoPUp

ActiveDocument.Variables(

"MyBudget").Setcontent "7000", true

if

MyBudget<8000 then

MsgBox

(MyBudget)

end

if

end

Sub

I want that Msgbox must print the value which is in MyBudget which is 7000.but when i m running this script ,the msgbox prints nothing .means a msg box with no value.. help me out .Thank u soo much

Regards

Sikandar

[#2 · Accepted solution]

Sikandar,

You need to retrieve the value:

ActiveDocument.Variables("MyBudget").GetContent.String

Regards,

Gordon

[#3]

HI

Thank u soo much Gordon.i have one another question.i want a msgvbox to appear which ask me "DO i want to go on the next sheet "if i click on Yes .it

must go on the next sheet .and i click on No it must stay on the same sheet.....any solution for this will be help fullll.Thank u soo much

Regrads

Sikandar.