Compressing multi used variables

**D_Rennie** · 07-03-2009, 10:16 AM

How are you guys.

What i would like to know is, In the code im using to make a phone call from a userform the varibles are set in each and every sub. It all works well though could they be compressed into only being used once like an option variable or somethink like that.
i know that more that one variable can be decleared at the same time of the same type "dim x, Y, z as long.

Please Login or Register  to view this content.

**D_Rennie** · 07-03-2009, 10:18 AM

I call these subs from the userform that why i made 3 copys like that.

**romperstomper** · 07-03-2009, 10:21 AM

Really, you only want one DialNumber routine, and then when you call it, you pass the number you want to ring as an argument. Your three routines are unnecessary as they are almost identical.

**D_Rennie** · 07-03-2009, 10:38 AM

Yes i had thet as a brain wave as i was typing it.
There realy is only about 3 changes between them.
I would like to keep it in its own module and im not sure if?how i can pass through the info for the double clicks of the textboxes. ( the only reason i want to keep it in its own module its getting aroung 1500 lines of code and i would get confused without some seperation"
There are 3 text boxes that have own numbers each with a double click. so if there where to share the same sub im thinking that i would need to store the number as a variable and use it for the tapirewuestmakecall. or what ive played with before using other userform items Textboxes captions list ect That seam sloppy though.

Cheers ill take a good look at how i can do it,

**romperstomper** · 07-03-2009, 10:45 AM

Your dialling routine would be like this:

Please Login or Register  to view this content.

and you would call it from each control using:

Please Login or Register  to view this content.

for example.

**D_Rennie** · 07-03-2009, 09:28 PM

Thankyou.
I will have a look after the weekend,

**D_Rennie** · 07-03-2009, 09:50 PM

I havent tryed anythink yet "not enough time todoy"
Though what i got from it is when calling a sub, A variable can be set to be used through the module. So DialPhone Combobox_List_Search.TextBox10.
Would that still be call DialPhone Combobox_List_Search.TextBox10?
then Sub DialPhone(strDial As String) textbox10 is like the transphered variable set as strdial.
If thats correct it makes sence though leaves alot of questions of what would refer to what using more than one variable.

Thankyou.

**D_Rennie** · 07-05-2009, 09:53 AM

romperstomper thanks for the help ive had a play around and understand passing the variables farily well. It works well with the dialing & left the msgbox in the module and passing variables to that fine.
Cheers.

The thing i dont get is why it dosent need the Call like i had before.