Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tc1983

    VLOOKUP VBA COMBOBOX

    Superb, thanks for all your help!
  2. tc1983

    VLOOKUP VBA COMBOBOX

    Getting a runtime error Could not set the value property. type mismatched!!??
  3. tc1983

    VLOOKUP VBA COMBOBOX

    this is what i have tradeid = Me.cmbtradeid.Value txtdateopen.Value = Application.WorksheetFunction.VLookup(tradeid, Range("A3:L49"), 2, False) have assigned a command button to call and getting this error "unable to get the vlookup property of the worksheet function class". Ideally i want...
  4. tc1983

    VLOOKUP VBA COMBOBOX

    setting the return to a text box within a form. combobox is named cmbtradeid textbox is named txtdateopen (getting a date) table range is A3:L49 Returning value from column 2. thanks for your help.
  5. tc1983

    VLOOKUP VBA COMBOBOX

    Sorry I am so confused with this all. Starting from the begining I have an xls with a unique number (tradeid). I want this to be the point of focus to return other values with the same row. VLOOKUP is the way forward? I am struggling to get my form text boxes to display the results of a vlookup...
  6. tc1983

    VLOOKUP VBA COMBOBOX

    I am trying to get a Combobox to be the lookup value. Have looked on many sites and cannot get to work, code is below tradeid = cmbtrade.Value dateopen = txtdateopen.Value dateopen = Application.WorksheetFunction.VLookup(tradeid, Sheets("Open_Positions").Range("A3:L49"), 2, False)

Part and Inventory Search

Back
Top