the showdataform function is obtained from using the data/form on the
main excel menu bar. If you type some numbers in the first few columns
and some titles in column A jan feb mar
i.e. Sales 100 200 300
op exp 20 30 40
then go to the menu and hit data then form you will see a dialog box. I
repeated the process with the macro recorder on then saved the macro.
Went into the tools, macro, and hit edit and when the macro coding comes
up you will see the line saying "activesheet.showdataform"



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!