Results 1 to 3 of 3

Thread: Combobox/textbox problem

  1. Apr 4th, 2006, 01:37 PM #1
    Albatross
    Albatross is offline

    Thread Starter
    Member
    Join Date
    Mar 2006
    Posts
    62

    Combobox/textbox problem

    I have a ComboBox on a userform that is fed from a named range on another sheet. On that same userform, I ahve a text box.

    What I'm trying to do is when I select an option from the combobox, I want the textbox to be coded to do a vlookup to the source sheet.

    I know how to do this on a plain sheet but having issues getting it to work on a userform/combobox/textbox format. Any help would be great.
    Last edited by Albatross; Apr 4th, 2006 at 02:00 PM.

    "If at first you don't succeed, destroy all evidence you ever tried."
    http://www.ussretribution.com
    Reply With Quote Reply With Quote
  2. Apr 5th, 2006, 02:24 AM #2
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Combobox/textbox problem

    Moved to Office Development forum
    Reply With Quote Reply With Quote
  3. Apr 5th, 2006, 02:41 AM #3
    zaza
    zaza is offline
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: Combobox/textbox problem

    Look at the Excel Tips and Tricks in my sig. There you'll find some handy code for the WorksheetFunction object, which will allow you to manipulate all Excel formulae, including the VLookup. Then it's just a case of referencing the sheet and range that you want.

    zaza
    I use VB 6, VB.Net 2003 and Office 2010



    Code:
    Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA,VB.Net) | Coordinates, Vectors and 3D volumes
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width