Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
commandbar with own textfield for datetime input ??
Hi,
is it possible to create an texfield in a commandbar and use it for my own userinput (for example time input ?) Application.CommandBars("mycommandbar").Controls.A dd Type:=msoControlEdit the command above is no problem i see an empty textfield in my commandbar but how can i use it in my excel macro ? i need it for date time input. thanks for evry help bye frank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
commandbar with own textfield for datetime input ??
Give it a caption so you can refer to it.
Sub AddEditControl() On Error Resume Next Application.CommandBars("mycommandbar") _ .Controls("MyEditBox").Delete On Error GoTo 0 With Application.CommandBars("mycommandbar") _ .Controls.Add(Type:=msoControlEdit) .Caption = "MyEditBox" .OnAction = "EditBox_click" End With End Sub Sub EditBox_Click() With Application.CommandBars("mycommandbar") _ .Controls("MyEditBox") MsgBox .Text End With End Sub -- Regards, Tom Ogilvy Frank Huebener wrote in message ... Hi, is it possible to create an texfield in a commandbar and use it for my own userinput (for example time input ?) Application.CommandBars("mycommandbar").Controls.A dd Type:=msoControlEdit the command above is no problem i see an empty textfield in my commandbar but how can i use it in my excel macro ? i need it for date time input. thanks for evry help bye frank |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
commandbar with own textfield for datetime input ??
Frank,
It's similar to other textboxes. Assuming you have set the Onaction property of your control, in that macro use something like MsgBox CommandBars.ActionControl.Text -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Frank Huebener" wrote in message ... Hi, is it possible to create an texfield in a commandbar and use it for my own userinput (for example time input ?) Application.CommandBars("mycommandbar").Controls.A dd Type:=msoControlEdit the command above is no problem i see an empty textfield in my commandbar but how can i use it in my excel macro ? i need it for date time input. thanks for evry help bye frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Datetime CSV format | Excel Discussion (Misc queries) | |||
Using Excel as a database and textfield | Excel Discussion (Misc queries) | |||
Date or datetime | Excel Programming | |||
formatting a TextField as DD-MMM-YY format | Excel Programming | |||
datetime in query | Excel Programming |