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 Rhinorhino 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 xuefang

  1. xuefang

    change font size of dropdown list

    Thank you very much.I follow your advice and I try to use Toolbox control to create the combo box.Now I can set font size and color of the dropdown list. It works fine.But I got another problem. I don't know how to set an onAction when user choose an item in the combo box. There are two parts of...
  2. xuefang

    change font size of dropdown list

    Thanks you very much. Now I know I can't control the font size of the combo box created by Forms control. But I really like this combo box, the code is simple and the box is clear and neat. Not like the combo box created by Control Toolbox, which is very complex.
  3. 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...
  4. xuefang

    inputbox method to get a formula

    After user enter the formula, I will copy this formula to the cells of the same row in all of the worksheets(about 100 sheets).
  5. xuefang

    inputbox method to get a formula

    Thank you very much. It works very well.I realized that I made a mistake in inputbox statement, I omitted "type:=0" part, I just copy those codes from exceltip.com. If as you say: let the user to input a formula into a cell, after he finish inputing. How can I continue my macro? How do I know he...
  6. xuefang

    inputbox method to get a formula

    hi,thank you for the reply 1.User not select a range in an inputbox. What I mean is: When inputbox method pop up a prompt window,the user can select a range using a mouse in the excel worksheet screen, and the address will show up in the inputbox window. 2.Call CreateNewItem2((hi))is just...
  7. 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...
See more

Part and Inventory Search

Back
Top