Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking up whether one item has a certain matching item Thocow Excel Worksheet Functions 6 March 31st 10 04:39 PM
Macro to ask for a item# and then show all details for that item Durai Excel Discussion (Misc queries) 5 December 4th 09 08:17 PM
To find rate of each item from item.xls and to copy price.xls pol Excel Discussion (Misc queries) 7 July 16th 09 12:49 AM
Item numbers result in item description in next field in Excel Cheryl MM Excel Worksheet Functions 1 February 20th 07 03:51 PM
Selecting an Item from a List and getting a different item to pop. Matt Excel Worksheet Functions 1 December 7th 04 02:37 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"