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!

Search results for query: *

  • Users: Robert1688
  • Content: Threads
  • Order by date
  1. Robert1688

    SelectionChange

    I've made the following to autofit the row of the cell I selected, but I want it to be the origin row height after another cell is selected. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target.EntireRow.AutoFit End Sub
  2. Robert1688

    Conditional Formatting

    I can only get three conditions, can I get more?
  3. Robert1688

    File folders

    Is there anyway to get folders' name and file name into spreadsheet automaticly? like this. MyDoc Pics Colleagues Remond.jpg Steve.jpg Family Friends Memos Kids Lucy Business Meeting There may be a file in Windows System, but I don't know which one.
  4. Robert1688

    The date & time of a cell is input

    I am creating a database which for inventory items stock. Is that possible to show the date and time in a cell of the same row where and when I input stock information?
  5. Robert1688

    Validation List

    Can a validation list in a cell is controled by another cell? For example: if in cell "A1" is "Fruit", then the validation list in cell "B1" will be "Apple", "Pear", "Orange"; if in cell "A1" is "Furniture", the the calidation list in cell "B1" will be changed to "Table", "Chair", "Sofa". I...

Part and Inventory Search