Microsoft Outlook email - Commandbutton ?

Outlook Banter (http://www.outlookbanter.com/)

- Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)

- - Commandbutton ? (http://www.outlookbanter.com/outlook-vba/57912-commandbutton.html)

I am entering info into Excel Sheet1 A1, B1, C1, D1. I want to click a
button (Submit) to move info to Sheet2 A1, B1, C1, D1. After I click button
I would like Sheet1 to be ready for new entries which when Submit is clicked
again will be moved to next rows on Sheet2 (A2, B2, C2,D2).

thanks
Bobby

For sure you'd get more answers in an Excel related news group. this one is
for Outlook.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Sat, 29 Sep 2007 16:16:00 -0700 schrieb Bobbykm:

I am entering info into Excel Sheet1 A1, B1, C1, D1. I want to click a
button (Submit) to move info to Sheet2 A1, B1, C1, D1. After I click
button
I would like Sheet1 to be ready for new entries which when Submit is
clicked
again will be moved to next rows on Sheet2 (A2, B2, C2,D2).

thanks
Bobby