View Single Post
  #1  
Old May 25th 10, 01:51 AM posted to microsoft.public.outlook.program_vba
Jonathan
external usenet poster
 
Posts: 49
Default userform combobox

Hi, using Outlook 2007. I have a simple userform that only has a combobox.
The problem is that I cannot enter a value and cannot select an item from the
list.

Enable=true
Locked=false

I don't know if this is a red herring... the multi-column combobox is loaded
using data from sql2005

Do Until rsClient.EOF
cboClientList.AddItem
For columnIndex = 0 To fieldCount
cboClientList.List(rowIndex, columnIndex) =
rsClient.Fields(columnIndex) & ""
Next columnIndex
rsClient.MoveNext
rowIndex = rowIndex + 1
Loop

The combobox has 4 columns that are all visible.

Any ideas or suggestions appreciated :-)

Many thanks,
Jonathan
Ads