|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
May 25th 10, 01:51 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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 |
|
#2
May 25th 10, 03:32 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
userform combobox
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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| combobox list in userform | robzrob | Outlook and VBA | 1 | May 24th 10 07:12 PM |
| Userform | Bre-x[_2_] | Outlook and VBA | 5 | March 18th 10 04:38 PM |
| userform in VBAProject.otm not working | Peter Hofman | Outlook and VBA | 1 | June 20th 09 04:17 PM |
| Cancel and Reset UserForm and macros | DStrong | Outlook and VBA | 3 | March 6th 09 09:55 PM |
| limit to number of controls in a userform? | cinnamngrl | Outlook and VBA | 2 | January 31st 09 06:31 PM |
Linear Mode
