more than one item Y/N ?

  • Thread starter Thread starter fitful_thought
  • Start date Start date
F

fitful_thought

I have set up a worksheet to record the details of items people buy from me
on eBay.

Using some help from a book, I created a macro that makes a letter in word,
which says thanks for purchasing my item.

Sometimes one person buys two, three or more items.

What code can I put into the macro that creates the word letter to ask me if
there is more than one item?

If anyone can help with this, I'd be very, very grateful indeed.
 
numItems = InputBox("How man items?")

??

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Y/N and print job sequencer 10
Extract item numbers with suffix -09 and copy them below the actuallist 4
More than one level of sub menus under the menu item 2
How to create a macro to generate report using advanced filter 13
Next Function in Array 5
How to create a bubble chart with more than 2 variables 0
list box remove item by combobox 4

Back
Top