Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Forms Control to Function
I want to write a function that checks a listbox for an entry and reports
true or false. I want the input to be the listbox to check and the potential entry. How do I pass the listbox to the function? Thanks, Pflugs |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Forms Control to Function
as an example
Function myFunc(lb As MSForms.ListBox) MsgBox lb.Value End Function and in the form myFunc Me.ListBox1 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pflugs" wrote in message ... I want to write a function that checks a listbox for an entry and reports true or false. I want the input to be the listbox to check and the potential entry. How do I pass the listbox to the function? Thanks, Pflugs |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Forms Control to Function
Function myFunction(myLB as msforms.listbox) as boolean
End Function I'm not sure what you mean by potential entry, though. Pflugs wrote: I want to write a function that checks a listbox for an entry and reports true or false. I want the input to be the listbox to check and the potential entry. How do I pass the listbox to the function? Thanks, Pflugs -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Forms Control to Function
Thank you, that worked well.
I have one more question, if you please. I am trying to return the value of a list item at index "i"; that is, looping through the list and reporting the string of the selected items. After reporting them, I'd like to remove them from the list, but each time I remove one, it changes the indexes. Is there a better way to get around this? Thanks, Pflugs "Bob Phillips" wrote: as an example Function myFunc(lb As MSForms.ListBox) MsgBox lb.Value End Function and in the form myFunc Me.ListBox1 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pflugs" wrote in message ... I want to write a function that checks a listbox for an entry and reports true or false. I want the input to be the listbox to check and the potential entry. How do I pass the listbox to the function? Thanks, Pflugs |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Forms Control to Function
loop in reverse
With listbox1 for i = .listcount - 1 to 0 step -1 if .selected(i) then .removeitem i end if next End with -- Regards, Tom Ogilvy "Pflugs" wrote: Thank you, that worked well. I have one more question, if you please. I am trying to return the value of a list item at index "i"; that is, looping through the list and reporting the string of the selected items. After reporting them, I'd like to remove them from the list, but each time I remove one, it changes the indexes. Is there a better way to get around this? Thanks, Pflugs "Bob Phillips" wrote: as an example Function myFunc(lb As MSForms.ListBox) MsgBox lb.Value End Function and in the form myFunc Me.ListBox1 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pflugs" wrote in message ... I want to write a function that checks a listbox for an entry and reports true or false. I want the input to be the listbox to check and the potential entry. How do I pass the listbox to the function? Thanks, Pflugs |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Forms Control to Function
Good call. Thanks.
Pflugs "Tom Ogilvy" wrote: loop in reverse With listbox1 for i = .listcount - 1 to 0 step -1 if .selected(i) then .removeitem i end if next End with -- Regards, Tom Ogilvy "Pflugs" wrote: Thank you, that worked well. I have one more question, if you please. I am trying to return the value of a list item at index "i"; that is, looping through the list and reporting the string of the selected items. After reporting them, I'd like to remove them from the list, but each time I remove one, it changes the indexes. Is there a better way to get around this? Thanks, Pflugs "Bob Phillips" wrote: as an example Function myFunc(lb As MSForms.ListBox) MsgBox lb.Value End Function and in the form myFunc Me.ListBox1 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pflugs" wrote in message ... I want to write a function that checks a listbox for an entry and reports true or false. I want the input to be the listbox to check and the potential entry. How do I pass the listbox to the function? Thanks, Pflugs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference between a Forms Control verus Active-X Control | Excel Discussion (Misc queries) | |||
Is tabbing function available when using control forms? | Excel Worksheet Functions | |||
passing variables between 2 forms | Excel Programming | |||
Passing variables between forms | Excel Programming | |||
User Forms - passing data between them | Excel Programming |