Update Cell in a Table with Value from User Form

macropod · #2 06-20-2016, 02:54 AM

Quote:

Originally Posted by wlcdo2

When I run through the code using the debugger, it works fine, but when I run the code for real (using an ActiveX button), the Bookmark is inserted at the location of the button that calls the UserForm, instead of the Table Cell.

That's because clicking on the ActiveX button changes the selection. You might do better to have your userform solicit the cell address to work with. Do note that Word VBA doesn't use A1 referencing so, if you solicit that, your code will need to transform it into rowindex & columnindex referencing.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Allow Multiple Content Control same cell of form table	DeborahBartlett	Word	1	01-04-2014 11:06 AM
Trying to update a table cell with a value based on a drop down box entry	mkasem	Word VBA	2	09-29-2013 08:36 PM
Text Form Fields - Filling the table cell	simville02	Word Tables	1	01-31-2013 11:12 PM
Update Outlook but user path changed	Ossie1972	Outlook	1	12-08-2010 08:19 PM
Text Wrapping on Fixed Lines in a Form field/Table cell	okrmjr	Word Tables	0	10-30-2009 08:52 AM