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 bkrike 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: *

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

    change font size of dropdown list

    I've created a combo box in excel with the macro recorder. This is the code that came back: Sub test1() ActiveSheet.DropDowns.Add(1305, 52.5, 242.25, 39).Select With Selection .ListFillRange = "$AW$4:$AW$18" .LinkedCell = "$AX$5" .DropDownLines = 5 .Display3DShading = False End With End Sub...
  2. xuefang

    inputbox method to get a formula

    I create a macro which ask the user to input a formula(user can select a range in the excel screen), then I copy this formula to a specific row of every worksheets. The problem is Application.InputBox("Insert a Formula", "This accepts Formula", 0+2) can not return the formula, it will...

Part and Inventory Search

Back
Top