Build the form with two textboxes

Have a commandbutton, and in its click event add the code

Me.Hide
myMacro Textbox1.Text, Text box2.Texy
Unload Me

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"alexanderd " wrote in message
...
i have started to develope an input form in which the input will set the
values for running the macro.

the form only has two input line
accno. which should be the value "crtiteria1"
& 2 account name which should be the value of the name ".NAME"

the initial form to appear and run before the macro runs and to vanish
(the form ) as the macro starts

can any one suggest a way in which this can be achieved


---
Message posted from http://www.ExcelForum.com/