passing variables to subroutine from userform

Hi, I'm relatively new to VBA excel programming and have gotten stuck on this problem. I have a sub procedure that is intended to load a list of values into a combobox; I wish to call this from a userform. The call from the user form needs to nominate/pass these variables so the called subroutine can identify the range for the values. The called subroutine is located in a separate module called "mod_ListboxTools".
Although I've spent some time looking (and experimenting) for what may be at issue my lack of VBA programming concepts is most probably bring me unstuck.
Any assistance appreciated.

Calling sub() located in a Userform

Please Login or Register  to view this content.

Called subroutine that is located in a module called "mod_ListboxTools"

Please Login or Register  to view this content.

Hi Norie,
Thanks for getting back, When stepping through the calling routine it hits the call statement at this line in the code and comes up with an error 13 - as below.

'call subroutine to load variables
mod_ListboxTools.ComboLoadList shtName, rngName, cboName, ufrmName

7-06-2013 3-20-11 PM.jpg

I've altered the called routine first line but still have the problem as described.

Please Login or Register  to view this content.

Hi Norie,
Mea Culpa!
(crap! - spent a long time trouble shooting a problem that was the code but not the code)

I had the same called routine in the userform code area - effectively repeating the code in two places. During trouble shooting I copied this into the same area to compare the code/s. It all runs now and looks like the following. Thanks for your assistance.

Please Login or Register  to view this content.

called sub() as below

Please Login or Register  to view this content.