I am trying to create a macro where apon clicking a commandbutton in a user
form assigned to a specific defintion it will go directly to a specific cell
within a specific range.  For example if the user named Brian Monaghan clicks
on the button for the definiton of analytics I ...

How do I assign a variable to a worksheet ?
I have a form into which I want to enter a number such as 2467 and when I
click on a command button in that form I want the number "2467" to become
the variable "myclasssheet" to work with the following command.

I tried to find a string in selected cells with the following code with
no success:
Sub Findstr()
Dim myStr As String

I declare a Variable as Public (to preserve its value throughout code
execution) eg:-
Public MyText As Variant (this is done in a Standard Module)
Then in a UserForm I have:-

Is there a way to see if user selects "Delete Sheet"?
I am trying to delete custom doc properties attached to that sheet when user
delete a sheet - how do I trigger this event? I don't see any ID number for
"Delete Sheet"

This is frustrating me to no end... I feel like it must be something
simple and I am missing it.
I have names defined in my worksheet which are defined as calculations.
I want to use those name (calculations) in my Macro's to display a

While recording a macro, I need to pause the recording and then restart.  I
can not find a way to pause recording and I'm not good at all with visual
basics editor.

I am trying to setup my Worksheet to only Enable buttons when there is
a date present in cell B2.  The script I have below works, but has some
issues.  Message box comes up twice, etc..
This is part of a Large Workbook with many macros the users steps thru.

I have a spreadsheet with a large expanse of empty cells. However,
because I used a vlookup command and copied out the results as their
values, then returned the results to the same locations, cells that
APPEAR empty do NOT register as blank. Any sugesstions how I can return

There is a syntax error, it stops on the On error go to errorhandler line.  
At one point there was a mention about needing a select in the case but now
it doesn't do that.
THANKS!

I have a row where I will be using tally marks.  I only want one
tally per row but it is based on a progression to track steps in the
process.  So if they have reached the next step they can just put a
tally (an X) in the new cell and it will auto replace the previous

I have an application in VBA were I dinamically add several controls to a
form. Im creating arrays of variables of type Control to access the added
controls, for ex:
Set ctrl_graph(i) = page_id.Controls.Add(add_chkbox_string, "ctrl_graph" & i)

Here a QA program that I have in Excel.  the user clicks a button then this
program loops through all the mdb files in a folder on our network.  Each
database has the same 12 tables but the databases all have different names.  
The program does a query on each table---just a ...

How can I go to a sheet by name, for example
I have a=0 (a is a string, not integer) and a sheet named 0. How can I
select the sheet using variable a?
Thanks for the help!

This is frustrating me to no end... I feel like it must be something
simple and I am missing it.
I have names defined in my worksheet which are defined as calculations.
I want to use those name (calculations) in my Macro's to display a