Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 04-24-2018, 12:09 PM
Logit Logit is offline Inventory: formula to show parts to order. Windows 10 Inventory: formula to show parts to order. Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Quote:
I got #REF!
If you did not change anything in the download workbook, you should not be receiving any errors. It works as intended here.

Quote:
What is the VBE?
In the download workbook, right click on Sheet1 tab, then select VIEW CODE.
What you see now is the VBE (Visual Basic Editor). When you are coding in VBA
(Visual Basic for Applications), which is what Excel runs on, the VBE is where you
place your code.

While in the VBE, double click on MODULE 1, on the left side of the screen. If all you see at first is MODULE (in the treeview display), double click on MODULE, then on MODULE 1.

When you double click on MODULE 1, on the right side of the screen appears the macro code that runs your ordering. In this particular project, this is all the code required to run your project. In other projects, you may find alot more code in different locations in the VBE. Depends on the need of the project.

Quote:
the other spaces to be blank
Do you mean on Sheet2 you want QUANTITY TO ORDER to display in Col B rather than
Col D ?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Inventory: formula to show parts to order. Formula/VBA to identify order of entry dates lesmielles Excel Programming 3 02-08-2017 06:14 AM
Timeline creation - show events out of order triallawyer PowerPoint 0 03-17-2015 08:48 PM
Changing order of animations in slide show mode mrbutler88 PowerPoint 1 02-14-2015 11:57 PM
Show & hide paragraphs, parts of tables, etc Preloader Word 2 10-19-2013 02:37 PM
Inventory: formula to show parts to order. add the functionality to show & hide paragraphs, parts of tables, etc pgwolfe Word 3 09-24-2013 07:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft