I created a Combo Box with a drop-down list that works fine at this point, but I would like the text in the box to appear highlighted, so that the user can just start typing to replace that value if desired.
As it is now, the first entry appears non-highlighted, and you have to double-click it to highlight it. You can press the Down Arrow to scroll through the choices, and then either press Enter, Tab, or Down Arrow to go to the next field in the form.
The initialization code for the form is below. What code will cause the text to be highlighted? Thanks!!
--Ray
Private Sub UserForm_Initialize()
CboxCategory.AddItem "CCCA"
CboxCategory.AddItem "Architect"
CboxCategory.AddItem "Contractor"
CboxCategory.SetFocus
CboxCategory.ListIndex = 0
End Sub
As it is now, the first entry appears non-highlighted, and you have to double-click it to highlight it. You can press the Down Arrow to scroll through the choices, and then either press Enter, Tab, or Down Arrow to go to the next field in the form.
The initialization code for the form is below. What code will cause the text to be highlighted? Thanks!!
--Ray
Private Sub UserForm_Initialize()
CboxCategory.AddItem "CCCA"
CboxCategory.AddItem "Architect"
CboxCategory.AddItem "Contractor"
CboxCategory.SetFocus
CboxCategory.ListIndex = 0
End Sub