Jchess
06-01-2012, 04:00 PM
I’m trying to write a Macro in Word 2003 that will determine which Option Button has been selected and put a value into an embedded (non-linked) Excel sheet. There are several groups, each group having 5 Option Buttons. Only 1 Option Button per group will be selected. Based on which Option Button is selected from a group, a value from 1 to 5 to be placed in the embedded Excel sheet.
This is easy enough when done exclusively within Excel using Value and Range statements, but I’ve had no luck figuring out how to accomplish it with Word Option Buttons that update an embedded Excel sheet. :banghead: Any suggestions will be greatly appreciated.
This is easy enough when done exclusively within Excel using Value and Range statements, but I’ve had no luck figuring out how to accomplish it with Word Option Buttons that update an embedded Excel sheet. :banghead: Any suggestions will be greatly appreciated.