Excel Combobox used as a pick list to populate different cells


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Excel Combobox used as a pick list to populate different cells

  1. #1
    Join Date
    Aug 2009
    Posts
    37

    Excel Combobox used as a pick list to populate different cells

    Hi,

    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.

    Talāt

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    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.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Aug 2009
    Posts
    37

    Unhappy

    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, 01:13 PM
  2. populate chart category from a combobox
    By RipIT in forum VB Classic
    Replies: 27
    Last Post: 02-21-2008, 09:01 AM
  3. Replies: 0
    Last Post: 03-11-2007, 10:14 AM
  4. data binding with ComboBox ( DropDown List Box )
    By software_develo in forum .NET
    Replies: 0
    Last Post: 08-07-2006, 11:31 PM
  5. Replies: 7
    Last Post: 05-11-2005, 04: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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