-The use of Me.Controls() was not recognized in a standard module.

true that you have to use full name of userform and controls out of the
userform module. like Userform1.Controls instead of me.controls.

"Minitman" wrote in message
...
| Hey Homey,
|
| Thanks for the reply.
|
| I tried to move the 7 subs. The use of Me.Controls() was not
| recognized in a standard module. There may have been other problems
| that had not shown up as well. I had to take the code back and call
| the macros without the variables (add a select case layer to choose
| the correct macro to run - oh well)
|
| Again, thanks for the effort
| -Minitman
| On Mon, 18 Jan 2010 09:31:13 -0500, "Homey" <none wrote:
|
| i think you need put InvCol_1 and the others in a regular module.
|
| "Minitman" wrote in message
| .. .
| | Greetings,
| |
| | I am attempting to run this macro :
| |
| | For this example x equals 1, 2 or 3. vName & vNum together is the
| | name of the originating TextBox.
| |
| | Here is the code fragment in question:
| |
| | Run "InvCol_" & x, vName, vNum
| |
| | This will run one of the three procedures known as InvCol_1, InvCol_2
| | or InvCol_3 each with the pass though arguments of vName & vNum.
| |
| | The problem is the VB error message:
| |
| | Run-time error '1004'
| | The macro 'InvCol_1' cannot be found.
| |
| | VB is calling it a macro, I'm not sure if that means anything or not.
| | The full name of the procedure is:
| |
| | Public Sub InvCol_1(vName As Variant, vNum As Variant)
| |
| | It is in the UserForm code area as is the rest of this code, It was
| | working until I changed the calling method to include a variable to
| | simplify the code.
| |
| | Can anyone see what I did wrong to mess up this code and, more
| | importantly, how do I fix it?
| |
| | Any help will be appreciated.
| |
| | -minitman
|