• Subject: RE: userform combobox
  • Author: Jonathan
  • Date: 24 May 2010
  • References: 1
I found it... it was my on change event that was causing issues...

thanks,
Jonathan

"Jonathan" wrote:

> 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
24 May 2010userform combobox.Jonathan
24 May 2010\ RE: userform combobox.Jonathan
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)