LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 470
Default Help to read and display data

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Read in Data Ronan Excel Programming 1 May 28th 09 05:39 PM
Share 2007 files on SBS 2003 server - read-only doesn't display us Extreme Guru Excel Discussion (Misc queries) 0 February 13th 08 09:37 AM
VB Code to 'read' .txt files and display info in Excel Petitboeuf[_4_] Excel Programming 1 December 19th 05 03:55 PM
How do I change the display of a negative number to just read 0? [email protected] Excel Discussion (Misc queries) 2 April 18th 05 11:03 AM
Read cell value and display Ben Excel Programming 2 November 10th 04 02:50 AM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"