Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Module not recogized

Posted on 2013-11-30
Medium Priority
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 49

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 49

Accepted Solution

Martin Liss earned 2000 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


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 49

Expert Comment

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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

721 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