Making a form not visible using a variable name

  • Thread starter Thread starter Bill Murphy
  • Start date Start date
B

Bill Murphy

I would like to pass a form name to a subroutine as a string, then make the
form not visible, something like the following:

sub HideForm(strFormName as string)

strFormName.visible = false

end sub

This fails of course. What is the correct VBA syntax when using a variable
as in this example?

Bill
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use of OpenArgs 5
ByPass key ms access 2016 0
Passing a form name to forms collection subroutine 2
Update subform with combobox change on main form 1
Problem checking if form is open 2
Can't make Monthview visible 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
HELP 6

Back
Top