Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rodesh

  1. rodesh

    Validate cell with a list of non repeating value

    Thanks Melone and Prex I want to make non repeating validation list directly from original list without intermediate column of list. It will better if it could me made by custom function in VBA. rodesh
  2. rodesh

    Validate cell with a list of non repeating value

    I have a column list containing e.g. Sunday Sunday Monday Monday Monday Tuesday .... ... Now I want to validate cell which shows list e.g. Sunday Monday Tuesday .. .. Without repeating values.
  3. rodesh

    Referencing VB userforms from Excel cell

    The main thing is That Userform1 of VBA refer to "Object" whereas Userform1 of cell A1 refere to "string" value so these are not comparable.The following is the simple code which would work for you.Assume you have three userforms. Sub Excelform() Select Case Cells(1, 1) Case...

Part and Inventory Search