View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vj Vj is offline
external usenet poster
 
Posts: 54
Default Early and Late Binding Vba Excel

Does any one help me why I can't refer to the form with this method in VBA
Excel.

dim var_sr_form_name as object
Set var_sr_form_name = ActiveWorkbook.VBProject.VBComponents("formName")

I get error when I use

var_sr_form_name.show method to show the form

or try to access any component of the form.

Thanks in advance for ur help.

VJ