I created an Excel user form and renamed it to "frmFormA".  I want the user
form to show when I open the workbook.  I use the following code in the
"ThisWorkbook" section of Microsoft Excel Objects in Visual Basic:
Private Sub loadWb()

I have about 600 rows that have a distinct combination of text and numbers
example:
P10062 - US-Executive Management
P10198 - MSN PUBLISHING PLATFORM                    

Hello all. Looking to add the finishing touch to this code I snagged
off a post someone made in this group (I apologize for not being able
to give credit to the author; this was 3-4 months ago). It's working
great for what I need it to do, but I wanted to change the From: field/

I've got a function that is supposed to select a range of cells in a
spreadsheet and run the print preview that selection.  But I keep getting
error 1004 with the above message, although I only seem to get this message
when there is already a selection in the applicable sheet.

Hi All.........
I am trying to disable all change-event macros (or even ALL macros) upon
opening a second workbook, with my code in the first workbook so the first
workbooks macros will function without any interference from the second

how can I control the limit of Excel?
I mean... Excel has the limit about sheets dipending from memory of
the pc.
Is there a way to stop it before it crashes??

As an example, I have a named array "aryXYZ" defined as:
={"abc","456","@#$"}     (and yes, I did use Ctrl+Shift+Enter)
I can get the second (or for that matter, any) element/entry into a a
cell with: =INDEX(aryXYZ,2)

Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Unprotect Password:="******"
ws.Columns("A:W").AutoFit

Hello Gurus,
Is it possible to copy DataForm Fields. If it is used to find the record can
i copy what is shown in DataForm fields to worksheet cell ?

Using the "add" button to add information to  a specified area, It
does Not add to the combobox
I am Still very new to vba and Not really sure what im doing wrong, i
want it to test if  the textboxes are empty, if they arent they

I've gotten a request from a user to program a VB macro that moves all rows
in a spreadsheet to the bottom if it contains a color (rgb(120,120,120))
I've been google'ing like nuts, but I've yet to find a solution that fits
the task.

I´ve made a simple macro to save 2 sheets do a txt tab separated. The
problem is that the numbers formated as "currency" (with a euro sign)
end up with a dollar sign in the resulting txt.
Does anyone knows why this is hapenning?

EVALUATE (xlfEvaluate) can be used to evaluate expressions containing calls to
VBA or XLL user-defined functions.
For instance, take this XLL function :
double MYFUNC(){

Situation: chemical reactants are measured; samples are mixed, each sample is
measured in two different enviroments, samples are measured in triplets, the
result should be an ideal path of the reactant through the changes of the
environment.

i have try the following but it won't let me  change the tab on sheet
2 where i put the code in
i want cell A1 on sheet 1 to change tab on sheet 2 the only way it
will change is if i type something in A! on sheet 2