View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Roberts Matthew Roberts is offline
external usenet poster
 
Posts: 2
Default Launch form from Array


Dear All

I am experiencing something of an impasse with my VB when
I try to show a form from an array of form names. My
initial attempts have revolved around the following code:

Run_Form_Array = Array
("New_RPI_Data_Frm", "Surveyor_Info_Frm", "Bank_Debt_Frm",
"Bond_Units_Frm", "Stock_Performance_Frm")

Form_Select = Run_Form_Array(Selection)
Unload Input_Menu_Frm
UserForm.Show (Form_Select)

I expect that it is the manner in which I either collect
or retrieve the names for / from the array.

Matthew