| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
change control listbox results to numbers
I have a listbox (activex control) in an excel worksheet, it returns a "text" value to the linked cell, when the item is selected from the list.
Since I want to do math with the result in the linked cell, how can I use vba to return a corresonding numeric value, instead of the text value. I know the listbox created from the "forms" menu, returns a number, but I like the versatility of the activex control better. I have tried to research this question for many days now, and can't find a reference to this problem. Has anyone else tried this? Any help is humbly appreciated. |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
change control listbox results to numbers
Better to ask in the excel.programming newsgroup. But use the .ListIndex
attribute of the listbox + 1 -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Gmann" wrote in message ... I have a listbox (activex control) in an excel worksheet, it returns a "text" value to the linked cell, when the item is selected from the list. Since I want to do math with the result in the linked cell, how can I use vba to return a corresonding numeric value, instead of the text value. I know the listbox created from the "forms" menu, returns a number, but I like the versatility of the activex control better. I have tried to research this question for many days now, and can't find a reference to this problem. Has anyone else tried this? Any help is humbly appreciated. -- Gmann |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
change control listbox results to numbers
In the same way. The .ListIndex attribute is the same for both listboxes
and comboboxes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gmann" wrote in message ... Sorry, I thought I had posted in excel. Thanks for the answer, how would I go about the same operation (below) with a group of comboboxes? Doug Robbins - Word MVP;457857 Wrote: Better to ask in the excel.programming newsgroup. But use the .ListIndex attribute of the listbox + 1 -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Gmann" wrote in message ...- I have a listbox (activex control) in an excel worksheet, it returns a "text" value to the linked cell, when the item is selected from the list. Since I want to do math with the result in the linked cell, how can I use vba to return a corresonding numeric value, instead of the text value. I know the listbox created from the "forms" menu, returns a number, but I like the versatility of the activex control better. I have tried to research this question for many days now, and can't find a reference to this problem. Has anyone else tried this? Any help is humbly appreciated. -- Gmann - -- Gmann |
|
#5
|
|||
|
|||
|
I think I'm starting to make use of it, thanks. One more question?
How do I sum the values (of the selected items ) from 2 different comboboxes in a single linked cell? All the selected items will have a value of 1, so it's just 1+1+1 etc. Thank you for your time. Quote:
|
|
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
change control listbox results to numbers
Dim i as Long
i = combobox1.Listindex+1 + combobox2.Listindex+1 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gmann" wrote in message ... I think I'm starting to make use of it, thanks. One more question? How do I sum the values (of the selected items ) from 2 different comboboxes in a single linked cell? All the selected items will have a value of 1, so it's just 1+1+1 etc. Thank you for your time. Doug Robbins - Word MVP;458172 Wrote: In the same way. The .ListIndex attribute is the same for both listboxes and comboboxes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gmann" wrote in message ...- Sorry, I thought I had posted in excel. Thanks for the answer, how would I go about the same operation (below) with a group of comboboxes? Doug Robbins - Word MVP;457857 Wrote:- Better to ask in the excel.programming newsgroup. But use the .ListIndex attribute of the listbox + 1 -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Gmann" wrote in message ...- I have a listbox (activex control) in an excel worksheet, it returns a "text" value to the linked cell, when the item is selected from the list. Since I want to do math with the result in the linked cell, how can I use vba to return a corresonding numeric value, instead of the text value. I know the listbox created from the "forms" menu, returns a number, but I like the versatility of the activex control better. I have tried to research this question for many days now, and can't find a reference to this problem. Has anyone else tried this? Any help is humbly appreciated. -- Gmann -- -- Gmann - -- Gmann |
|
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
change control listbox results to numbers
Dim i as Long
i = combobox1.Listindex+1 + combobox2.Listindex+1 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gmann" wrote in message ... I think I'm starting to make use of it, thanks. One more question? How do I sum the values (of the selected items ) from 2 different comboboxes in a single linked cell? All the selected items will have a value of 1, so it's just 1+1+1 etc. Thank you for your time. Doug Robbins - Word MVP;458172 Wrote: In the same way. The .ListIndex attribute is the same for both listboxes and comboboxes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gmann" wrote in message ...- Sorry, I thought I had posted in excel. Thanks for the answer, how would I go about the same operation (below) with a group of comboboxes? Doug Robbins - Word MVP;457857 Wrote:- Better to ask in the excel.programming newsgroup. But use the .ListIndex attribute of the listbox + 1 -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Gmann" wrote in message ...- I have a listbox (activex control) in an excel worksheet, it returns a "text" value to the linked cell, when the item is selected from the list. Since I want to do math with the result in the linked cell, how can I use vba to return a corresonding numeric value, instead of the text value. I know the listbox created from the "forms" menu, returns a number, but I like the versatility of the activex control better. I have tried to research this question for many days now, and can't find a reference to this problem. Has anyone else tried this? Any help is humbly appreciated. -- Gmann -- -- Gmann - -- Gmann |
|
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
change control listbox results to numbers
In the same way. The .ListIndex attribute is the same for both listboxes and comboboxes. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Gmann" wrote in message ... Sorry, I thought I had posted in excel. Thanks for the answer, how would I go about the same operation (below) with a group of comboboxes? Doug Robbins - Word MVP;457857 Wrote: Better to ask in the excel.programming newsgroup. But use the .ListIndex attribute of the listbox + 1 -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Gmann" wrote in message ...- I have a listbox (activex control) in an excel worksheet, it returns a "text" value to the linked cell, when the item is selected from the list. Since I want to do math with the result in the linked cell, how can I use vba to return a corresonding numeric value, instead of the text value. I know the listbox created from the "forms" menu, returns a number, but I like the versatility of the activex control better. I have tried to research this question for many days now, and can't find a reference to this problem. Has anyone else tried this? Any help is humbly appreciated. -- Gmann - -- Gmann |
|
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
change control listbox results to numbers
Better to ask in the excel.programming newsgroup. But use the .ListIndex
attribute of the listbox + 1 -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Gmann" wrote in message ... I have a listbox (activex control) in an excel worksheet, it returns a "text" value to the linked cell, when the item is selected from the list. Since I want to do math with the result in the linked cell, how can I use vba to return a corresonding numeric value, instead of the text value. I know the listbox created from the "forms" menu, returns a number, but I like the versatility of the activex control better. I have tried to research this question for many days now, and can't find a reference to this problem. Has anyone else tried this? Any help is humbly appreciated. -- Gmann |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing features of a blocked text results in the change of every | Microsoft Word Help | |||
| Changing features of a blocked text results in change of the entre | Microsoft Word Help | |||
| how do I control page numbers in a section break? | Page Layout | |||
| Change placement of translation results so they are in view. | Microsoft Word Help | |||
| using control center then change to control left takes the item c. | Microsoft Word Help | |||
Hybrid Mode
