Excel VBA, Userform w/ ComoboBox


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Excel VBA, Userform w/ ComoboBox

  1. #1
    Join Date
    Aug 2007
    Posts
    58

    Question Excel VBA, Userform w/ ComoboBox

    I am trying to find a way to create a macro that will take the data selected from the combo box and concatenate it with the data found in cells.

    For Example:

    Combo Box Selection - "Test"

    ID (Column A) - Before
    12345
    98765
    99999
    55555
    empty cell
    23232

    ID (Column A) - After
    12345 Test
    98765 Test
    99999 Test
    55555 Test
    empty cell
    23232

    If any further information is needed, please let me know.

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego
    Posts
    202
    You'll want to look into looping over ranges using the Range() method and then call the ActiveCell properties to update the values.

    Here is a page with a tutorial on using comboBox controls in Excel.

    http://www.excel-vba.com/vba-24d-combo-boxes.htm

    Good luck,
    Michael Sanchez
    Managing Technical Editor
    Forum Moderator
    FreeVBCode.com

Similar Threads

  1. Excel VBA cannot see C# COM DLL methods
    By banerji in forum .NET
    Replies: 7
    Last Post: 07-07-2007, 10:28 PM
  2. Excel VBA add-in portability
    By amotto in forum VB Classic
    Replies: 0
    Last Post: 03-25-2007, 08:05 PM
  3. Replies: 1
    Last Post: 01-02-2007, 09:58 AM
  4. Workbook not Closing Properly by Excel VBA
    By blayne in forum VB Classic
    Replies: 1
    Last Post: 11-17-2005, 07:14 PM
  5. Excel, VBA, SQL, DAO 3.6 help needed
    By Jared Evans in forum VB Classic
    Replies: 2
    Last Post: 05-29-2003, 05:44 PM

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