View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default How to show User Form when form name is in string?

Don,

I could not remember how to do this, but Googling came up with this method:

VBA.UserForms.Add("UserForm1").Show

hth,

Doug


"Don Wiss" wrote in message
...
If I want to reference a control by a string name I use:
Me.Controls("Checkbox" & i).Value

So, in VBA code how do I display a User Form with the form name in a
string? Application.Run ?

Don <www.donwiss.com (e-mail link at home page bottom).