Object error when shifting sub from Form to Module

**rpjwhite** · 10-12-2016, 05:16 AM

All,

I am pretty new to coding and I am sure this question has probably been answered a million times before and people think I am complete muppet (they are not wrong)
Anyway...

So I have an excel sheet with 4 userforms which are basically duplicates of each other except the last control button which does things slightly different. Therefore a value eg. LA.Value is used in all 4 userforms.

When I originally coded it I left all the code in all the userforms and a lot of it is duplicated and it worked (after a lot of trial and error). But trying to be smart I wanted to shift the duplicated subs to a module. When I try and to this I get object error.

I am sure the fix is really simple but my hours spent trawling here and google in general have turned up nothing. Help!

Code in Userform:

Please Login or Register  to view this content.

Sub in module:

Please Login or Register  to view this content.

**S O** · 10-12-2016, 05:19 AM

Please add code tags to your code, you can do this by highlighting the text and pressing the [#] button on the editor toolbar.

This makes the code easier to read (plus that bright green text just hurts my eyes!)

**rpjwhite** · 10-12-2016, 05:22 AM

newb error, hope that helped.

**cytop** · 10-12-2016, 05:32 AM

I would guess LA is a control on a userform and so is not in scope in the module...

The simplest fix is to change the procedure declaration and pass the value from the calling sub

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**S O** · 10-12-2016, 05:35 AM

Originally Posted by rpjwhite

newb error, hope that helped.

certainly did, thanks.

**rpjwhite** · 10-12-2016, 06:02 AM

Thanks Cypto will try that and revert.
LA is a textbox and I don't really declare it anywhere. Now trying to get my head round scope.

**rpjwhite** · 10-12-2016, 11:12 AM

Thanks everyone
Cypto's method worked shame I am checking so much stuff but hey ho.

Object error when shifting sub from Form to Module

LinkBack

Thread Tools

Rate This Thread

Display

Object error when shifting sub from Form to Module

Re: Object error when shifting sub from Form to Module

Re: Object error when shifting sub from Form to Module

Re: Object error when shifting sub from Form to Module

Re: Object error when shifting sub from Form to Module

Re: Object error when shifting sub from Form to Module

Re: Object error when shifting sub from Form to Module

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Fix an error in MODULE to run Sub Workbook_SheetDeactivate(ByVal Sh As Object)

[SOLVED] Module object error

[SOLVED] Compile error: Member already exists in an object module...Trying to create a form

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

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

Runtime error on form (No object)

In Excel vba how do you Launch code a standalone Module from a Form or other Module ?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions