Textbox in custom toolbar

Question

Is it possible to put textbox control in custom toolbar in Excel. I have created an Add-in that shows this toolbar. What I want to do is when user types in textbox Add-in should call a procedure or function depending what user has typed.

I would like to do it in VBA in MS Excel.

Thanks.

What version of Excel are you using ? (Ribbon UI or Command Bars?) — RedBlueThing
– RedBlueThing, Commented Apr 17, 2009 at 0:59

RedBlueThing · Accepted Answer · 2009-04-17 01:04:27Z

4

If you are using Excel 2007 and have implemented IRibbonExtensibility::GetCustomUI then you can use the following XML to define an edit box in your Addin GUI:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
    <ribbon startFromScratch="false">
        <tabs>
            <tab id="MyTab" label="My Tab">
                <group id="MyGroup" label="My Group">
                    <editBox id="MyEditBox" getText="MyEditBoxCallbackgetText" label="Editbox Label" onChange="MyEditBoxCallbackOnChange"/>
                 </group>
            </tab>
        </tabs>
    </ribbon>
</customUI>

answered Apr 17, 2009 at 1:04

RedBlueThing

42.6k17 gold badges99 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

THEn Over a year ago

That looks good. I should consider to upgrading to 2007. Thank you.

RedBlueThing Over a year ago

When I get a chance I can give you the code for 2003, walking out the door right now ;)

cyberponk · Accepted Answer · 2017-02-15 20:19:19Z

1

I found out:

Sub test()
    Set myControl = CommandBars("Test").Controls.Add(Type:=msoControlEdit, Before:=1)
    With myControl
        .Caption = "Search"
        .OnAction = "Tester"
    End With
End Sub


Sub Tester()
    MsgBox "I am gonna search for: " & CommandBars("Test").Controls(1).Text
    CommandBars("Test").Controls(1).Text = ""
End Sub

edited Feb 15, 2017 at 20:19

cyberponk

1,88421 silver badges22 bronze badges

answered Apr 24, 2009 at 17:50

THEn

1,9364 gold badges29 silver badges35 bronze badges

Collectives™ on Stack Overflow

Textbox in custom toolbar

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related