Prompt user input on how macro will behave

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a word doc that I use for printing inventory labels. I don't use the
"Labels and Envelopes" that doesn't work for me. I have fields and drop down
boxes to select certain items to go into the label (ex, vendor name, CD or
DVD). Once I have the first label done, I have a macro that will copy that
label 5 times. Is it possible to include a prompt box on how many times to
copy?
After I create the label, I want to be able to run the copy macro and then
it prompts user as to how many times it should copy.
 
This is almost certainly possible - post your code (pasted into a message)
in the vba newsgroup and ask for help there - but I have to wonder why you
find it necessary to reinvent the wheel. Microsoft's label wizard works fine
and for more complexity you can have mail merge for which you'll find a
variety of information in relation to labels on my web site.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Thanks for your reply Graham. The labels are printed on a dot matrix
printer-I just created a custom label based on the size of the label. My
labels consist of

Product:
Company: (drop down box: Adobe, Corel, Microsoft, etc)
Model:
Serial#:
Barcode#: Disks: Media: (drop down box: CD,
CD/DVD, Floppy)

I have to copy/paste the product, serial#, and barcode# from another program.
The Company and Media fields have drop down form boxes which I select the
vendors from (I had to manually enter the vendor names to create the list).
Looking at your website, I suppose I could use mail merge, but how am I
supposed to get the Product:, Serial#, etc. ? I don't iknow how I could
create the data source like this. From what I understand, the data source is
where all the information to creat the labels comes from. I can't get all my
information that way-it comes out of a separate program. Does that make any
sense?
 
A data source need only be as simple as a table containing as many columns
as you want fields. Put a heading on the top and your data one record per
row.

I don't know the nature of your third party application, but it sounds like
some sort of database. Check to see if it can output the data in a format
Word can recognise - such as a comma delimited file. Word can read a wide
variety of data formats.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top