Passing variables from sub to user form

**boc_est1986** · 08-18-2009, 06:52 AM

I can pass a variable from sub to sub no problem and have tried to do it the same way between a sub and user form but i keep getting the error

Compile Error:
ByRef argument type mismatch

This is the code i am using

Please Login or Register  to view this content.

Can someone help please

**se1429** · 08-18-2009, 07:36 AM

Hi,

This message means that one or more of the data types defined in your form are not the same as those in the module. If your module is declared like this:

Please Login or Register  to view this content.

Then ABC should have the same data type as CLICK and XYZ should have the same data type as ADDRESSES in your CALL statement.

**royUK** · 08-18-2009, 07:39 AM

What are you actually trying to do? What aer you expecting UserForm1.Show(click) to do?

**boc_est1986** · 08-18-2009, 08:08 AM

i have a sheet that i need to run a filter on to pull out certain data, is then saved as a temp file and attached to an email, the userform contains a combo box with several cases in, for each case there is a number of email addresses that the attachment is then sent to. Because the new workbook is book1, book2 etc the click is counting how many new sheets are created and using that to get to the relevant window. As the name of the main workbook changes with each week i cannot deirectly reference the sheets as it can get messy. I need to pass the click variable and the addresses from the appropriate case to a sub that then sets up and sends the email. i can attach a copy of the spreadsheet if it would help

**boc_est1986** · 08-18-2009, 08:15 AM

ok my bad sorry, i hadn't declared addresses in the sendmail function

this is the working code

Main Page

Please Login or Register  to view this content.

User Form

Please Login or Register  to view this content.

send mail

Please Login or Register  to view this content.

**royUK** · 08-18-2009, 09:09 AM

Sounds messy to me, can you attach an example workbook with dummy data in? I can't see why you don't create the temp file, email it then delete it. Certainly you could rename it on creation.