🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.apps.spreadsheets
Article #66

Re: Excel Macro's help needed! :)

#66
From: Sparky
Date: Mon, 10 Aug 1992 15:35
32 lines
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!cadnews
References: <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