Take an Excel List and Add to Word Combo Box

macropod · #1 04-11-2019, 03:54 PM

So what error message, if any, does the macro report?

I see, too, that you haven't changed the sheet name in:
StrWkShtNm = "Sheet1"
without that change, it isn't going to work.

dlafko1 · #2 04-12-2019, 05:32 AM

I uploaded the image of the error and the word document. I left the excel sheet name as sheet1 (went back to it) because of the error, I figured the more alike they are the less chance of error. I passed this in the VBA Section and Under the macro section, just to try and make sure it was not me.

Quote:

Originally Posted by macropod

So what error message, if any, does the macro report?

I see, too, that you haven't changed the sheet name in:
StrWkShtNm = "Sheet1"
without that change, it isn't going to work.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing Drop Down List to Combo Box	workingspade	Word	7	06-13-2024 01:17 AM
Letter Template /w combo box list	etruz	Word	4	10-31-2018 05:16 AM
Word 2010 Content Control help - Combo Boxes vs Drop Down List	proghy	Word	1	09-16-2014 02:01 PM
How can I add hyperlink to open a word file from an excel combo box selection?	mahmoudramadan	Excel	0	10-20-2012 10:41 AM
Bold list items in a combo box	DrewB	Word VBA	0	07-17-2009 11:32 AM