Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a value from a combobox drop down list through code
I am copying a value from a spreadsheet cell to a combobox
FormInput.ComboBoxRim1.Text = Range("d17"); text in d17 is Bo The text Bob appears in the combobox correctly but the cursor location is on a blank space to the right of b thus Bob is not found in the dropdown list If I enter the combobox manually and backspace so the cursor is on top of b then all other code works properly Is there any way to paste from a spreadsheet to a combobox form and have the text recognize that it is contained in the list array Terr |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a value from a combobox drop down list through code
Terry,
How about FormInput.ComboBoxRim1.AddItem Range("d17") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "TerryK" wrote in message ... I am copying a value from a spreadsheet cell to a combobox. FormInput.ComboBoxRim1.Text = Range("d17"); text in d17 is Bob The text Bob appears in the combobox correctly but the cursor location is on a blank space to the right of b thus Bob is not found in the dropdown list. If I enter the combobox manually and backspace so the cursor is on top of b then all other code works properly. Is there any way to paste from a spreadsheet to a combobox form and have the text recognize that it is contained in the list array? Terry |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a value from a combobox drop down list through code
Bob,
Thanks for the quick reply. A good suggestion but it was not successful. I am populating the combobox list with an array. I suppose I could redim the arrays but there are quite a few of them. I will keep looking for more ideas. Terry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi Select from Drop List | Excel Discussion (Misc queries) | |||
ComboBox drop list when clicked on??????????? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
select drop down list 1 value will change the value in dr... | Excel Worksheet Functions |