ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   more than one item Y/N ? (https://www.excelbanter.com/excel-programming/304960-more-than-one-item-y-n.html)

fitful_thought

more than one item Y/N ?
 
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.


--
Regards,
David



Bob Phillips[_6_]

more than one item Y/N ?
 

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)

"fitful_thought" wrote in message
...
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.


--
Regards,
David






All times are GMT +1. The time now is 11:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com