+ Reply to Thread
Results 1 to 3 of 3

From Excel to Word VBA, an exercise in frustration

  1. #1
    Registered User
    Join Date
    02-21-2014
    Location
    Edmonton, Alberta
    MS-Off Ver
    Word 2010
    Posts
    2

    Angry From Excel to Word VBA, an exercise in frustration

    I have a table with 2 columns with text-based drop-down lists. Here's an example of what I want to do: If I select "Likely" in column 1 and "Moderate" in column 2 (of row 1), it should return "Medium" in column 3 and set the background color to yellow (of row 1). In excel (vba), I'd verify both lists for the row have a value, do a lookup in a table, set the "value" for the cell using offsets and use conditional formatting on the cell.

    Enter Word 2010. I'm aware of using the OnExit Event for content controls (no OnChange event?, that's pretty lame) and I understand that "bookmarks" are analogous to "named ranges" in Excel.

    I've spent half a day and I'm spinning my wheels on this. Any general ideas on the best way to code this in Word? Between trying to reference the table, using bookmarks to add/delete text and formatting the table cells, I'm starting to pull my hair out.

    Any help you can offer is appreciated.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: From Excel to Word VBA, an exercise in frustration

    Not especially difficult! Try something along the lines of:
    Please Login or Register  to view this content.
    I'll leave you to fill in the blanks, so to speak.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    02-21-2014
    Location
    Edmonton, Alberta
    MS-Off Ver
    Word 2010
    Posts
    2

    Re: From Excel to Word VBA, an exercise in frustration

    Thanks for the detailed response Paul. I'll give it a whirl.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Columbia student exercise, Monthly > Quarterly data by Macro exercise
    By alepenn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2011, 12:04 AM
  2. Difficult Excel exercise
    By sarisman in forum Excel General
    Replies: 6
    Last Post: 06-14-2008, 12:12 PM
  3. DIV/0! Frustration
    By dtevol in forum Excel General
    Replies: 3
    Last Post: 05-06-2008, 09:06 AM
  4. Solver Frustration
    By zealot in forum Excel General
    Replies: 1
    Last Post: 11-10-2006, 11:49 AM
  5. open new instance of excel. Plese cure my frustration
    By matt charlton in forum Excel General
    Replies: 2
    Last Post: 05-23-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1