Drop Down List Box size too small

D

Darin Kramer

Howdie,

I have created a macro that launches a drop down list box, problem is
the list box is to small, left to right, to hold the length of
charchters I want to include in it, how do I change the length or style
of the list box....

Below is extracted code in case it sheds some light....

Thanks

D

' Set properties of the drop-down list box.
Set cbcCommandBarListBox = _
.Add(Type:=msoControlDropdown)
With cbcCommandBarListBox
.AddItem " .Add new sample"
.AddItem " .Modify exisiting sample"
.ListIndex = 1
.Caption = "I want to.."
.Style = msoComboLabel
.BeginGroup = True
.OnAction = "LaunchMacro_comment"
.Tag = "lstSet_Sample_size"
End With


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
T

Tom Ogilvy

The CommandBarCombobox has a width property. Try setting that to something
wider.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

creating Toolbar on Word 2000 using built-in Visual Basic Editor 0
"scroll to" by list box selection 1
Input Box w/Drop Down List 5
VBA to alter selection in a Drop Down Box 1
Select a drop-down box 1
creating Toolbar on Word 2000 using built-in Visual Basic Editor 0
Creating Toolbar on Word 2000 (Urgent) 0
Formatting combo box drop-down list 2

Top