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 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
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
Do not advance to next cell helphv Excel Worksheet Functions 6 October 14th 08 02:10 PM
Finding Advance Filter Reference in Source Sheet SteveT Excel Discussion (Misc queries) 6 September 28th 07 09:09 PM
automatically advance to next cell jmiller8 Excel Discussion (Misc queries) 4 August 21st 07 01:36 PM
Cell advance i.e. tab Rita Palazzi Excel Discussion (Misc queries) 3 January 16th 07 11:51 PM
Advance to predetermined cell JLatham Excel Worksheet Functions 2 January 10th 07 05:07 AM


All times are GMT +1. The time now is 05:47 AM.

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

About Us

"It's about Microsoft Excel"