Microsoft Office Forums - View Single Post - [Solved] Creating and Referencing Drop Down Text Boxes in VBA code

cjkmarx · 12-12-2016, 08:27 AM

I have a word document that was originally created in Word 2010 and it has three drop down list boxes and in the VBA code I have the following code:

Code:

Public Sub Document_Open()
With Me.RevisedTotalDropDown
  .AddItem "0-700k"
  .AddItem "700k-750k"
  .AddItem "750k-10M"
  .AddItem "10M+"
End With
 
With Me.adminMod
  .AddItem "Yes"
  .AddItem "No"
End With
 
With Me.ForeignSupplier
  .AddItem "Yes"
  .AddItem "No"
End With
 
With Me.Subk_Type
  .AddItem "Choose One:"
  .AddItem "FFP (Firm Fixed Price)"
  .AddItem "FP-LOE (Fixed Price, Level of Effort)"
  .AddItem "CPAF (Cost Plus Award Fee)"
  .AddItem "CPAF-LOE (Cost Plus Award Fee, Level of Effort)"
  .AddItem "CPFF (Cost Plus Fixed Fee)"
  .AddItem "CPFF-LOE (Cost Plus Fixed Fee, Level of Effort)"
  .AddItem "T&M (Time and Materials)"
  .AddItem "LH (Labor Hour)"
  .AddItem "Other (Discuss Below)"
End With
End Sub

This has worked fine for over a year even when we first upgraded to Word 2013 it worked fine, but suddenly on some computers it is no longer working. I am getting an Compile error: Method or data member not found. It is erroring on the Me.RevisedTotalDropDown, Me.adminMod, and Me.Subk_Type. It is no longer recognizing the drop down list boxes. What could have caused this to happen and how can I fix this issue? I am thinking that it may be a Word or Office update that is causing the issue. Any ideas? Thanks!