+ Reply to Thread
Results 1 to 3 of 3

navigate through defined values in cell with arrow key

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    San Jose
    MS-Off Ver
    Excel 2003
    Posts
    2

    navigate through defined values in cell with arrow key

    Hi there,

    I've programmed before but I'm new to VB so please help me. I want to have a user select a cell (any cell in a column) in the worksheet and then he/she should be able to press the "UP" or "DOWN" arrow keys to navigate through values. It is similar to a drop down menu. For example I would have predefined values such "STOP","GO","START". When the user selects the cell and hit the arrow key once, the value of the cell changes to "GO", hit the arrow key again, the value changes to "STOP", and so on....
    thank you any help!

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: navigate through defined values in cell with arrow key

    Hi serge2487 and welcome to the forum. The best way for us to help you with something like this is to create a mock workbook with non-sensitive data or personal information. In this mock workbook, you should provide a before and after representation of what you want to do. Doing so will help us to help you tremendously.

    Regards:
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Registered User
    Join Date
    10-05-2011
    Location
    San Jose
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: navigate through defined values in cell with arrow key

    I've never heard of mock workbook haha. Thanks for the tip, will do!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1