JeffT
11-09-2008, 04:44 AM
Hi (probably easy for somebody, but not me)
I have a combobox in Outlook which picks up data from an Excel spreadsheet and works fine. You can also type your own text.
I was wondering if its possible to have the dropdown list already down when the form opens to reduce the number of clicks by one when selecting.
It may not be possible or perhaps it's done through properties or code, but I can't figure it out.
I can use a Listbox but can't then enter data manually.
I've tried a TextBox but can't figure out if it can pick up the 5 items from the spreadsheet.
Thanks
JeffT
I have a combobox in Outlook which picks up data from an Excel spreadsheet and works fine. You can also type your own text.
I was wondering if its possible to have the dropdown list already down when the form opens to reduce the number of clicks by one when selecting.
It may not be possible or perhaps it's done through properties or code, but I can't figure it out.
I can use a Listbox but can't then enter data manually.
I've tried a TextBox but can't figure out if it can pick up the 5 items from the spreadsheet.
Thanks
JeffT