DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009

    Excel Combobox used as a pick list to populate different cells


    I am enhancing an invoice application I am developing and have been toying with the idea of using a combo box to select from a list a particular product and put the value in a cell. It works fine, although I have some other aspects of it which I will try and sort later.

    My immediate problem is that, I need to repeat teh selection process from teh Combobox, for each lien of teh invoice ( some 10 lines) on each occasion droping teh value in a different cell. ie D20, D21, D22, D30. Is there a way of doing that? I am using the linkedcell function of the Combobox property. and it works well for the first time. Is there a way of using a VBA incremental function to increase d20 to d30 step by step?

    Thanks for any help.


  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    Move away from the linked cell (which I've never like anyway - it is way too constrictive) and do what you need to do through VBA programming code.

  3. #3
    Join Date
    Aug 2009


    Thanks Hack.

    Unfortunately, my VBA skill are not up to it. With the linked cell option, I thought I was almost there. But if you say, it can't be done, then I think its time I give up.

Similar Threads

  1. Replies: 2
    Last Post: 08-05-2008, 12:13 PM
  2. populate chart category from a combobox
    By RipIT in forum VB Classic
    Replies: 27
    Last Post: 02-21-2008, 08:01 AM
  3. Replies: 0
    Last Post: 03-11-2007, 09:14 AM
  4. data binding with ComboBox ( DropDown List Box )
    By software_develo in forum .NET
    Replies: 0
    Last Post: 08-07-2006, 10:31 PM
  5. Replies: 7
    Last Post: 05-11-2005, 03:56 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.