Search results for query: *

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...

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.

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...

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).

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...

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...

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...