Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Previously, we used a sheet (paper) to order our supplies, then key in what
was needed. In trying to go paperless, I have programmed excel for most of what I need to do. However, I need help with the following: I have a macro that will read data (list of items stocked and its max qty) into an array when the user clicks the button "Begin Order". It gets the data from a list on a worksheet in the same workbook. Then there will be a userform that displays the list one item at a time. The userform will display one item, and its max qty, at a time. The user will enter the amount on hand and the macro will calculate amount needed to order. Each time the user hits ENTER, the amount needed to order will be entered in the form on the worksheet and the next item will display in the userform. How do I get the data, that is initially read into an array, to the userform one at a time? Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Read in Data | Excel Programming | |||
Share 2007 files on SBS 2003 server - read-only doesn't display us | Excel Discussion (Misc queries) | |||
VB Code to 'read' .txt files and display info in Excel | Excel Programming | |||
How do I change the display of a negative number to just read 0? | Excel Discussion (Misc queries) | |||
Read cell value and display | Excel Programming |