Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Reference Cells/Formulas in Word97 Table??

Feb 24, 2004 4:36AM PST

I am trying to design a simple form with a drop-down box containing "open" and "close." Based on the input in this drop-down, two other cells have to to reflect the chosen option, and the alternate one (i.e. if "open" is chosen, cell XX will read "OPEN" and cell YY will read "CLOSE," or vice-versa.

I can do this in Excel easily, but the formulas in Word just don't want to work. I have tried bookmarking the box, and can *copy* the bookmark value to a cell, but cannot use the bookmark in a formula.

HELP!! =8-O

Discussion is locked

- Collapse -
Re:Reference Cells/Formulas in Word97 Table?? No. OLE!
Feb 24, 2004 5:20AM PST

You would have to use OLE or "embed" a spreadsheet into the Word document.

Bob

- Collapse -
Re:Re:Reference Cells/Formulas in Word97 Table?? No. OLE!
Feb 24, 2004 5:30AM PST

I've tried inserting the Excel spreadsheet right into the document, but one must double-click the spreadsheet to operate it, (you can't even do that once the form is locked) and to add insult to injury, the column and row lines show up. What a headache! I'd just re-do this form in Excel, but Word documents link to our GoldMine software automatically. I can't do that with Excel.

Any further input will be appreciated. (If I can't figure it out, though, the secratary will just have to remember to input the proper values!)

Andy

- Collapse -
Re:Reference Cells/Formulas in Word97 Table??
Feb 24, 2004 6:04AM PST

I suppose (but it's not much more than an assumption) that this would be possible with not too difficult Visual Basic coding. Visual Basic in Word 97 is one of those many things I don't master, and I don't even have the Visual Basic for Word helpfile installed on this machine.

It should be possible to assign coding to the buttons you're making. And it's certainly possible to do something with a table in the coding. A quick google search found http://www.visualbasicforum.com/t139173.html where the width of a column is adjusted in VB. If you can adjust the width, is a reasonable assumption you can change the value also. Either with a 'value' property/method, or something with 'select' and simply putting it there.

And the same google search found http://www.amazon.com/exec/obidos/tg/detail/-/1572313889/102-8557315-9561705?v=glance
Your boss might be willing to let you buy a book like this. But this site might be helpful also: http://visualbasic.about.com/cs/programmingvba/
or try this google search: http://www.google.nl/search?q=vba+word+table+value

Hope this helps. It's not exactly a ready made solution, but if you like programming, you'll find interesting stuff, I'm sure.

Kees

- Collapse -
Re:Re:Reference Cells/Formulas in Word97 Table??
Jun 3, 2004 1:19AM PDT

Kee,


I didn't realize you replied (and you may not see this), but thank you very much for taking the time to do so. I'm not familiar with VB either, tho' I'm willing to learn. For the time being, I'm whimping out, and letting the user select both boxes. Maybe when I have some spare time (yeah, right!) I'll dig into the resources you provided. Thanks again!

Andy