Article View: comp.apps.spreadsheets
Article #66Re: Excel Macro's help needed! :)
From: Sparky
Date: Mon, 10 Aug 1992 15:35
Date: Mon, 10 Aug 1992 15:35
32 lines
1932 bytes
1932 bytes
In article <sgolby.713433201@guinevere> sgolby@st.nepean.uws.edu.au (Scott Golby) writes: > Hi Everyone, I'm drawing up some dialog boxes for a friend of >mines accountancy business. I'm supposed to be the computer person >but I know nothing about Excel! :) Anyway I have draw the boxes >using the dialog editor and pasted them into the work-sheet via the >clip board. But I can't get the things to display. > I highlighted and named the area that defines the dialog box in >question. and put =DIALOG.BOX(diag_name) on the left hand col, but >all that did was come up with an error! > What do I do to get these things to run? > > ( I think I'll go back to programming in 'C' its much easier! ) > > 'C' ya... > >-- >********************************************************************** >* Scott Golby BBS +61-(0)47-36-6263 v32 * >* University of Western Sydney, Nepean - Kingswood * >* sgolby@st.nepean.uws.edu.au FIDO : 3:713/616 * > Forgive me if I insult your intelligence, but are you aware that dialog boxes and the function "DIALOG.BOX()" should be part of a MACRO worksheet rather than a "normal" worksheet? When you select "New " from the "File" menu, it will ask you what type of New sheet you want. You should select Macro Sheet. If that's not it, please post some sample code and I'll try again. --Sparky
Technical Details
Message-ID:
<1992Aug10.153521.20679@nrtpa038.bnr.ca>Path:
arc1-ca.pugleaf.net!sparky!uunet!pmafire!news.dell.com!natinst.com!cs.utexas.edu!hermes.chpc.utexas.edu!news.utdallas.edu!corpgate!brtph560!nrtpa038!cadnewsReferences:
<sgolby.713433201@guinevere>Show Full Headers
Complete Article Headers
Newsgroups: comp.apps.spreadsheets Path: arc1-ca.pugleaf.net!sparky!uunet!pmafire!news.dell.com!natinst.com!cs.utexas.edu!hermes.chpc.utexas.edu!news.utdallas.edu!corpgate!brtph560!nrtpa038!cadnews From: Sparky Subject: Re: Excel Macro's help needed! :) Message-ID: <1992Aug10.153521.20679@nrtpa038.bnr.ca> Sender: cadnews@nrtpa038.bnr.ca (netnews posting host) Organization: None Worth Mentioning References: <sgolby.713433201@guinevere> Date: Mon, 10 Aug 1992 15:35:21 GMT Lines: 33