🚀 go-pugleaf

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

In article <1992Aug10.153521.20679@nrtpa038.bnr.ca> Sparky writes:
>
>If that's not it, please post some sample code and I'll try again.

Hi,

I'm new to this group and am looking for some excel guru's to ask
questions of. Here's a basic description of what I am trying to do and
if anyone thinks they may be able to give me a hand I would appreciate
it.

I am using Excel 4.0 for Windows. I've set up a workbook (.xlw) that
contains (at least) four files. One is a macro sheet that contains all
the macros that I need to use, cmodel.xlm, the second is a database of
parts, parts.xls, the third is the spreadsheet that the user wants
filled out, product.xls, and the fourth is just a README file to give
some info on what the workbook does and to use it.

The basic mode of operation is that the user will list a sequence of
numbers in column A of the worksheet, and then run a macro that copies
a series of formulas across the row based on the "class" of the number
(e.g. 0, <1000, <10000), then takes the actual number and goes out to
the database worksheet and extracts some data that relates to that
specific part.

One problem I am running into now is that the formulas may depend on
something like a tax rate, so I would like to define that as a defined
name and then the formula would be something like say
F23*Tax_Rate. What I am finding is that each time it copies that
formula in, it askes me if I want to use the existing definition of
that named variable. If there are 30-100 such lines and several such
variables it drives one crazy. 

So if you have experience writing macros in excel and would be willing
to answer some questions, please let me know. If you are willing/able
to respond to emailed questions or take a phone call, please let me
know.

Thanks in advance.

Avi Feldblum
AT&T
avi_feldblum@att.com
215-939-3748

In article <1992Aug12.174812.15658@cbnewsk.cb.att.com> ayf@pruxp.att.com (Avi
Feldblum) writes:
>Hi,
>
>I'm new to this group and am looking for some excel guru's to ask
>questions of. Here's a basic description of what I am trying to do and
>if anyone thinks they may be able to give me a hand I would appreciate
>it.
>
>I am using Excel 4.0 for Windows. I've set up a workbook (.xlw) that
>contains (at least) four files. One is a macro sheet that contains all
>the macros that I need to use, cmodel.xlm, the second is a database of
>parts, parts.xls, the third is the spreadsheet that the user wants
>filled out, product.xls, and the fourth is just a README file to give
>some info on what the workbook does and to use it.
>
>The basic mode of operation is that the user will list a sequence of
>numbers in column A of the worksheet, and then run a macro that copies
>a series of formulas across the row based on the "class" of the number
>(e.g. 0, <1000, <10000), then takes the actual number and goes out to
>the database worksheet and extracts some data that relates to that
>specific part.
>
>One problem I am running into now is that the formulas may depend on
>something like a tax rate, so I would like to define that as a defined
>name and then the formula would be something like say
>F23*Tax_Rate. What I am finding is that each time it copies that
>formula in, it askes me if I want to use the existing definition of
>that named variable. If there are 30-100 such lines and several such
>variables it drives one crazy. 
>
>So if you have experience writing macros in excel and would be willing
>to answer some questions, please let me know. If you are willing/able
>to respond to emailed questions or take a phone call, please let me
>know.
>
>Thanks in advance.
>
>Avi Feldblum
>AT&T
>avi_feldblum@att.com
>215-939-3748
>

I'll be happy to respond to you via internet (I don't have mail access), but
cannot commit to giving phone advice.  (I'm a consultant and get paid for my
time.)

In answer to your specific problem, try turning error checking off,
"=ERROR(FALSE)", immediately before pasting, then back on again.  This usually
supresses Excel's messaging.

More importantly, using COPY()/PASTE() in macros really gums up the works.  Try
using the OFFSET() function instead.  It effectively copies and pastes, but is
MUCH faster.

Good luck!

-- Sparky