View Single Post
 
Old 04-24-2018, 12:09 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 533
Logit 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