Suspected Error in "Excel 2002 VBA" book

rstober · September 10th, 2003, 07:28 PM

Hi,

Thank you for writting this book. I have been searching and searching for information on how to controls dynamically and progamatically. I haven't found this inforamtion anywhere else, certainly not on Microsoft's site. In particular, I like the info on dynamically creating event procedures.

That being said, I'm trying to use the code on page 210. I've typed the code exactly as shown in the book. But when I right click in a cell, I get "User defined type not found". The editor opens and the folowing code is highlighted:

Ctl As MSForms.ComboBox

I don't know why it's not found, but I am using Excel 2000.

Can you please look at this?

Also, the book lists author John Green at [email protected] but there's no such address. No big deal, but it is incorrect.

Thank you,

Robert Stober

Birger · September 11th, 2003, 10:05 AM

Did you remember to set the references, i.e. 'Microsoft Forms 2.0 Object Library' ?

rstober · September 11th, 2003, 04:26 PM

No I didn't set any references... How do I do that?

Thank you for your response,

Robert

Birger · September 12th, 2003, 01:09 AM

Choose
Tools - References
and select the references needed.

Deepesh_Jain · September 12th, 2003, 04:26 AM

you no need to type the code. just download it from the site.

Quote:

quote:Originally posted by rstober
Hi,

Thank you for writting this book. I have been searching and searching for information on how to controls dynamically and progamatically. I haven't found this inforamtion anywhere else, certainly not on Microsoft's site. In particular, I like the info on dynamically creating event procedures.

That being said, I'm trying to use the code on page 210. I've typed the code exactly as shown in the book. But when I right click in a cell, I get "User defined type not found". The editor opens and the folowing code is highlighted:

Ctl As MSForms.ComboBox

I don't know why it's not found, but I am using Excel 2000.

Can you please look at this?

Also, the book lists author John Green at [email protected] but there's no such address. No big deal, but it is incorrect.

Thank you,

Robert Stober

Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team

sommersm · September 1st, 2004, 06:33 PM

Hi,

Does anybody know of a way to set the references (i.e. "Microsoft Forms 2.0 Object Library") using VBA? We have created a workbook for other people to use but we don't want to give them access to the VBA Editor to change the references themselves. Thus, we want the code to do it for them.

These users have complained of an error in the program even though it works on our own computers. In light of this, I suspect that the references on their computers may not have the above reference.

Regards
Michael

gcianfanelli · September 2nd, 2004, 06:00 AM

Try using this example from within your MS Office project:

Code:

Public Sub addFormsRef()
  addRefFromFile "C:\WINDOWS\System32\FM20.DLL"
End Sub

Private Sub addRefFromFile(ByVal fileName As String)
  Dim ref As Object

  For Each ref In Application.VBE.ActiveVBProject.References
    If StrComp(ref.FullPath, fileName, vbTextCompare) = 0 Then
      Exit For
    End If
  Next

  If (ref Is Nothing) Then
    Application.VBE.ActiveVBProject.References.AddFromFile fileName
  End If
End Sub

Guido

sommersm · September 2nd, 2004, 05:48 PM

Guido,

Thank you for the reply. Will try the code and email back if there are still any issues.

Regards
Michael