Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advance cell reference
I am trying to use a userform for order entry (item number & qty). I am at
the point that I can enter only one item and place it in the appropriate cells, but I need to be able to advance the cell reference for each entry. The userform uses two command buttons: ENTER and FINISHED. Currently I am using an click event on ENTER to process the info entered by user. Prior to showing the userform, I have selected A13. Column A (starting with A13) is ItemNum and Column B (starting with B13) is the qty. I appreciate any suggestions on how to accomplish this task. Thank you in advance, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do not advance to next cell | Excel Worksheet Functions | |||
Finding Advance Filter Reference in Source Sheet | Excel Discussion (Misc queries) | |||
automatically advance to next cell | Excel Discussion (Misc queries) | |||
Cell advance i.e. tab | Excel Discussion (Misc queries) | |||
Advance to predetermined cell | Excel Worksheet Functions |