Return the value of a Combo Box Selection using a Function

[swapon_uiu]

Dear All,
Hope you all are fine. I got a question regarding retrunig of a combobox value using a function.

I am a userform where I got a combobox and two commmand button. One for cancel and another for OK.

I have a procedure in which I call the userform with the combobox. When the combobox appears, I will select a value from that combobox and press 'Ok' button and I want that value to be passed to my procedure (basically what I selected from the combobox). I want that value to be returned through a function so that I got 3 more procedures where from I need to call that userform with the combobox again and again.

Is there any one who can help me out?


Thanks in advance.

[Norie]

Why do you need a function?

Can't you get the selected value directly from the combobox?

Please Login or Register  to view this content.

[swapon_uiu]

I know how to get the value from the combo box. My problem is I want to return that value using a function because my 3 other procedures will be able to use that function's returned value, which will enable me to filter my huge data. It is cumbersome to copy 3 more same userform with same combobox input for 3 procedures. So it would be better to return the value of a combobox and use that value in my different procedures.

[bakerman2]

A function will simply pass the value to whatever Sub it's calling and then it's gone (the function won't hold the value).

What you need is a variable to which you assign the value of the combobox so you can call it time and time again.