View Single Post
 
Old 11-17-2016, 12:04 PM
Katherine1995 Katherine1995 is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2016
Posts: 4
Katherine1995 is on a distinguished road
Thumbs up Problem resolved....(RCA: ActiveX content controls in Building Block)

Hi,

The above change in Range did not work either. The problem was the content controls in the building block. INSERT does not work in a loop if building block has any ActiveX component as it has to assign unique name for each of them at every INSERT in the document and I was initializing them on document OPEN & NEW event. So, when I redefined the blocks with non-ActiveX drop downs it just worked.

@ guessed : Thanks for all your help.

Cheers
Reply With Quote