How to set Outside Procedure?

Hi everyone,

I have the following codes used with a user form, but they are all not working due to an outside procedure problem, any suggestions?

Please Login or Register  to view this content.

Thanks,

Exactly,, Thanks alot,

Hi all,

What if we want to use the same property with Ranges like:

Please Login or Register  to view this content.

It is giving an error!

Is there another property to set an outside procedure for ranges that can be used for all modules codes, all forms codes and all modules and forms codes in a workbook?

Thanks,

Please Login or Register  to view this content.

I don't think you will be able to do the above.
Const means CONSTANT, as in it doesn't change, but your range is dynamically finding the end of the data, so it CAN'T be const.
Also the action of determining that range has to take place at some point, so it can't be outside of a procedure.
What you could do is something like this:

Please Login or Register  to view this content.

Of course you "MyRange" will only be selecting all of your data as long as it doesn't change dimensions. If part of the rest of your code adds an extra line to the worksheet, then "MyRange" will still refer to the old size.

Now I am using as same code as you provided merged with (with) property, but I have many controls in the userform .. do I have to repeate the same Range in all of them???

No you could have the range set almost anywhere you like, perhaps in the workbook open routine, IF it is not going to change.

Can You please provide me with an example of that Phil??

I have the following placed in the 'ThisWorkbook' area of code in the VBA Editor. Then you can use 'MyRange' anywhere that you need to reference that range.

Please Login or Register  to view this content.

That's sooooooo great,

Thank you very much ,, that's what I am looking for since a long time.

Hi,

After testing the code providied by Phil_V, it seems that the workbook doesn't recognize the range at workbook startup (Auto_Open), so when the range is needed to run a macro completely an error msg appears telling that an object is required ( I think the required object is the range we referred to in Auto_Open).

Can you please find me a solution for that problem?

Thanks,

Hi everyone,

I really need to know how to set a public range for the whole workbook, I don't think that is not possible in VBA,

Can you please help me???

Sorry, I have been away for a while, it's very strange that it doesn't work properly, but a slight change sorts that out

In the 'ThisWorkbook' code area:

Please Login or Register  to view this content.

Then in Module1 (or where you are writting your code):

Please Login or Register  to view this content.

Obviously when you run the "Put_In_Ones" macro it will fill your range with 1's. Not overly useful, but shows that it works.
Of course don't forget as well that you MUST already have some data in Column C of Sheet2 after row 4, otherwise your range will be invalid.

Hi,

The problem is still existing, Can you please post a workbook contains an example for that.

Thanks,

Leith Ross, Thank you so much for your detailed clear reply,