Module not recogized

Posted on 2013-11-30
Last Modified: 2013-11-30
Open the attached workbook and select the first tab. When you click on the command button it is to call a module but gives me an error object missing. I have checked my spelling and attached within the workbook the modules I am using.
I'm out of options to launch this module.
Question by:Frank Freese
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 47

Expert Comment

by:Martin Liss
ID: 39687407
The only code in the workbook is this which is in the UserDefinedDetectCells sheet. When that sheet is activated the code runs so please restate the problem.

Private Sub cmdDisplayDataDetectCells_Click()
End Sub
Private Sub Worksheet_Activate()
Selection.NumberFormat = ";;;"
End Sub

Open in new window


Author Comment

by:Frank Freese
ID: 39687423
In the "cmdDisplayDataDetectCells" command button (Display Data) I call a module "DetectFormatCells"
I've included the module in the worksheet. Do you see the code in the command button?
LVL 47

Accepted Solution

Martin Liss earned 500 total points
ID: 39687432
There is no module and no procedure called DetectFormulaCells. Do you want the code that's in Worksheet_Activate to run when you click that button? Do you want it to run from both places?No module
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

by:Frank Freese
ID: 39687454
For reasons unknown the modules I used were NOT were they were suppose to be. Good catch

Author Closing Comment

by:Frank Freese
ID: 39687455
thank you
LVL 47

Expert Comment

by:Martin Liss
ID: 39687457
You're welcome.

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel compare strings 6 54
converting excel into labels 6 37
Excel 2016 - Link to (or reference) sheet within another workbook 9 61
Userform to show a range in excel. 3 33
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question