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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tc1983

  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)
See more

Part and Inventory Search

Back
Top