Anyone know how to assign a Macro to a Commandbutton?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlos - 26 Sep 2007 21:29 GMT

I'm having trouble tying in a macro to a command button I place at the end of
a Word form. The Macro exports the filled-in info to a spreadsheet, but I
don't see anything in the button's properties that would execute the
macro...???

Reply to this Message

Karl E. Peterson - 27 Sep 2007 23:30 GMT

> I'm having trouble tying in a macro to a command button I place at the end of
> a Word form. The Macro exports the filled-in info to a spreadsheet, but I
> don't see anything in the button's properties that would execute the
> macro...???

Open the Visual Basic Editor, double-click "ThisDocument" in the Project Explorer
window, then select "CommandButton1" (or whatever you called it) in the "(General)"
dropdown at the upper-left in that code window. This is the routine that will
execute when that button is punched.

Signature

.NET: It's About Trust!
http://vfred.mvps.org

Reply to this Message