Results 1 to 3 of 3

Select Empty Cell Within a DropDown List Box's Range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Select Empty Cell Within a DropDown List Box's Range

    Hi all,

    I've got a drop down pick box that I'm using.
    Under format Controls, I have the following control settings:
    Input range: $K$6:$K$16
    Cell Link: H4
    Drop down lines:10

    Cells K6 and K16 are empty cells.

    The formula
    =INDEX($K$5:$K$16, $H$4)
    ,
    shows my selected cell value from the given range.


    I would like to, be able to through code, set my selection to one of the empty cells.
    I tried recording a macro to log the event but nothing was recorded.

    Any help is appreciated.

    Thanks,
    BDB
    Last edited by bdb1974; 03-05-2010 at 06:59 PM.

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