Constants, user-defined types not allowed as Public members

secici

New Member
Joined
Sep 21, 2002
Messages
43
Hi!

I wanted to declare a user-defined type for easy-manipulation of some of my strings. And I also wanted them to be declared as "Public" so I can access them whereever needed. But My ExcelXP VBA tells me that

Constants, user-defined types etc. etc. are not allowed as Public members of object modules

On the other hand in the Help "const" topic it can easily be seen that there is no restriction on declaring public constants.

What is the background of this dilemma? Is it possible to overcome this problem of mine in a different way?
This message was edited by secici on 2002-11-02 07:05
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
Did you try declaring your constant in the Modules instead of a UserForm or worksheet?
 

secici

New Member
Joined
Sep 21, 2002
Messages
43
I think I' ve tried declaring user-defined data type in a module but it didn't work. But I'm not sure now. I'll take a look again.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,215
Messages
5,594,883
Members
413,947
Latest member
gizmolucy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top