Member already exists in an object module form which this object module derives error

**Sc0tt1e** · 09-30-2014, 08:53 AM

Within the attached document I have 2 Userforms (HR & SetUp). The HR code is run from the left button called "New Case".

I am attempting to run the code in the HR form and when the Setup code is removed it works perfectly but once I loaded the SetUp code into the form I get the above error message.

Google tells me that the error occurs because an object and a sub have the same name(within the SetUp form I assume) but this is all run from the CommandButton1_Click Private sub and I cannot locate anything out of place in the code or in the forms.

Can anyone see what the error is referring to please as I was up to 4.30am this morning trying to fix this bug?

**cytop** · 09-30-2014, 09:35 AM

You have Varaibles with the same name as Objects on a form...

Dim Mort As Boolean, CC As Boolean, Ins As Boolean, PPI As Boolean, IRHP As Boolean

The variable Mort clashes with the Mort object (checkbox), CC also, and a couple of others...

**Sc0tt1e** · 10-01-2014, 02:39 AM

I have done this before and it has never been an issue. I thought because they are check boxes I had to declare the data type, if they were true or false,long, integer etc?

**romperstomper** · 10-01-2014, 03:14 AM

No - you can't use the same name at module level (and you shouldn't at procedure level either). You've also got an issue here:

Sub Startup()

Startup.Show

End Sub

You should rename the routine ShowStartup.

And another here (in the CommandButton1_click ):

.Offset(0, 5).Value = Today()

because Today() is a worksheet function. In VBA you use Date().

And here:

    .Offset(0, 16).Value = SetUp.Town.Text

There is no control called Town - perhaps you meant City?

There are more references to non-existent controls, as well as attempts to use Strings as objects.

Member already exists in an object module form which this object module derives error

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Member already exists in an object module form which this object module derives error

Re: Member already exists in an object module form which this object module derives error

Re: Member already exists in an object module form which this object module derives error

Re: Member already exists in an object module form which this object module derives error

Thread Information

Users Browsing this Thread

Similar Threads

Module vs Object

Setting module-level object variables

[SOLVED] Declaring Object References at Module Level

Compile error: Member already exists in an object module from which this object modul

To access a previous object via class module

Bookmarks

Bookmarks

Posting Permissions