userform combobox

Status
Not open for further replies.
J

Jonathan

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
 
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
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R combobox list in userform Outlook VBA and Custom Forms 1
R Adding Userform Dropdown List items from names of subfolders on network drive Outlook VBA and Custom Forms 10
A Outlook Userform Size Outlook VBA and Custom Forms 2
N Activity Tracking with Userform Outlook VBA and Custom Forms 4
D Next Available Meeting with Userform Variables Outlook VBA and Custom Forms 1
A Populate Excel from Outlook Userform Outlook VBA and Custom Forms 3
B Insert Hyperlinks for attachments in Userform Outlook VBA and Custom Forms 5
D Change sender name outlook vba 2010 Custom Userform Outlook VBA and Custom Forms 1
A Open CHM file from VBA Userform Outlook VBA and Custom Forms 4
L Outlook 2007 - Userform Using Outlook 2
A Focus on the userform Outlook VBA and Custom Forms 15
F Outlook 2010 - outlook userform and combo boxes Using Outlook 9
L Userform Field Month and Date. Using Outlook 19
Witzker insert Date & Time (HH:mm) no (ss) in userform Using Outlook 6
A insert Date & Time in userform Using Outlook 3
X VBA: Confused with variables between ThisOutlookSession and UserForm Using Outlook 1
L UserForm Code For Contact Links Using Outlook 76
M Progrescreas Bar in Outlook UserForm Using Outlook 1
C UserForm and ordering variables Outlook VBA and Custom Forms 3
B Userform Outlook VBA and Custom Forms 5
W Using Excel UserForm from Open Workbook in Outlook VBA Outlook VBA and Custom Forms 5
P userform in VBAProject.otm not working Outlook VBA and Custom Forms 1
K Incorporate selection from combobox into body of email Outlook VBA and Custom Forms 0
T Outlook Template - textbox visible based on combobox selection Using Outlook 1
Z Add ComboBox Value to Body of Email Outlook VBA and Custom Forms 1
C Trying to populate an appointment ComboBox from Excel Outlook VBA and Custom Forms 2
N Select Appointment subject line from combobox or list Outlook VBA and Custom Forms 1
C Autofill subject line in appointment from options selected in combobox Using Outlook 6
B Contact Page 2 Combobox via Registry Outlook VBA and Custom Forms 6
N Combobox in outlook add ons toolbar not firing event on main window resized Using Outlook 3
S Dynamically add recipients using combobox and checkbox????? Using Outlook 2
K Alignment in Combobox Outlook VBA and Custom Forms 1
P Setting combobox properties from Outlook 2007 Add-in Outlook VBA and Custom Forms 9
K Adding watermark to Combobox in Outlook. Outlook VBA and Custom Forms 1
C ComboBox data Outlook VBA and Custom Forms 2
D ComboBox with Multi columns Outlook VBA and Custom Forms 4
S ComboBox (using Commas) Outlook VBA and Custom Forms 4
E Where is the best place to store values for combobox entries Outlook VBA and Custom Forms 5
E Where is the best place to store values for combobox entries Outlook VBA and Custom Forms 5

Similar threads

Back
Top