Passing a Form into a function

[romanemul]

Hello dear forum users,

Im making a application where i have couple of listboxes on a form. The problem is that my code is repeating too much so im trying to avoid this repetitive code.

for i = 1 to listbox.ListCount......

boilerplate code to find selected index

So i decided to make a function with the form as an input and an output of an selected index.

Private Function selectedIndex(ByVal lstbox As MSForms.ListBox) As Integer

for i = 1 to lstbox.ListCount......

so im running the function like this

idx = selectedIndex(listbox)

The problem is that when i pass a name of a form it pass only bounded value. I even tried to pass a form as an object but wihout luck.


Can anyone provide me a hint how to pass an form ?

Thanks in advance.

 

[RoryA]

Your function takes a listbox, not a form, so I don't understand your question. Can you clarify?

 

[romanemul]

Sorry my bad .

It supposed to be

"So i decided to make a function with the listbox as an input and an output of an selected index."

and

"The problem is that when i pass a name of a form it pass only bounded value. I even tried to pass a form as an object but wihout luck."

supposed to be

"The problem is that when i pass a name of a listbox it pass only bounded value. I even tried to pass a listbox as an object but wihout luck."

and the topic name is also bad


supposed to be "Passing a listbox into a function"

Sorry

 

[RoryA]

What makes you think it’s only passing the value of the list box?

 

[romanemul]

I wanted just to pass a just a pointer of a listbox to function which is faster than passing the whole form.

but hey. I have made few changes in my code and it returns me correct index and previously it returns me just -1.

Completely stupid and bogus question.

Thanks anyway Rory


Rom