Excel VBA - Variables in Public worksheet to be used in a UserForm?

Yes, you're right. You can insert a module then declare a public variable that any sub in your project can use.

Or depending on how you've written your code, you might want to break your larger macro up into several smaller macros and then piece them together in a main macro. For example Macro1 may delete all the extra rows. Macro2 may sort the data. And Macro3 may filter the data. Instead of writing a big lengthy macro every time and re-writing the same code over and over again. You can break it into chunks and put them together in a main macro. So the main macro would simply look like this:

Sub Main

Call Macro1

Call Macro2

Call Macro3

End Sub

Vba Public Variable

This site has experts in VBA

http://www.xtremevbtalk.com/

If you visit this site, you will need to specify what Operating System

you use (NTFS or Vista or 32-bit) and what version of Excel. Excel 2003 or Excel 2007. They are fussy but will assist you if you include code as well. Be descriptive as much as possible. Don't assume everyone knows your thoughts. Use Code tags to enclose any vba code.

Example -

[CODE]

Sub whatrever()

blah blah blah

end sub

[/CODE]

You will need to create a free account to access their services.

Here are some home pages of projects by a VBA enthusiast -

http://www.geocities.com/excelmarksay

http://au.geocities.com/excelmarksay

if you are in the same form and working with vba then you can define by the following:

Me!Input_Name.Value

or

Form_Name!Input_Name.Value

if you are trying to get a value in another form you have to use:

Form_Name!Input_Name.Value