I have Excel 2000 and Excel 2007 installed on my machine.
When i create a personal macro workbook in Excel 2007, it creates it in
xlsb format, and also places it in the same folder that Excel 2000
checks for the personal Macro Workbook.

I set ws1 as sheet1 or sheet2 on Userform1.
I need to reference ws1 on Userform2, but it doesn't seem to recognize ws1.
How do I make ws1 public to all forms?  I just have Public ws1 as Worksheet
before my code on Userform1

I have this function:
   myKey = Key()
   Selection.Value = myKey
If the user highlights a range, a specific value is filled into every single

Is it possible to add a line of code to a command button to set the focus to
a particular textbox, so it ready for the user to type there?

When i close a workbook through code such as :
sub button6()
Application.DisplayAlerts = False
ActiveWorkbook.Save

On the currently active sheet cell F2 has the name of the sheet I want to
make active.  How do I activate this sheet?
thanks,
ck

Is there a way to tell if you code is 'leaking memory'? Once in awhile it has
trouble and has to close excel... :(

I spent about 8 hours coding a form, set the workbooks on open property to
show the form. Saved and closed the file, when I re-opened I get System Error
&H8000FFF Catastrophic Failure. Using XL V. 11.8146.8132. The repaired file
shows an error log that says 'lost vb project' and ...

I found this in the help file:
   Worksheets("Sheet1").Activate
Do I need to use this .activate command and then this:
with worksheets("sheet1")

We know that for putting an arrya formula we use "Range.formulaArray"
property.
But what about if I need to use an array formula result in the context of my
code (like myVar =workbook.formula) and passing it to my variable, without

My sheet2 has a list a data, four columns wide.  My userform shows this data
with buttons 'prev' and 'next' as per the code mentioned here recently.  I
have a button 'delete' that needs to remove the row 'rownumber'.
Is this very hard to do???

My userform, which has been using data from sheet1, will give the user an
option to edit a list on another sheet, sheet2.  A command button will open
different form that pertains to cells on sheet2.  I'll use code similar to
this, below.  Do I need to somehow make sheet2 the ...

On a userform, a combobox with choices 1 through 10.  I have the control
source set to sheet1!A10, but in the field A10, nothing happens until I leave
the focus from the combobox.  So I have to click on some other control, or
close the form.  I need my chooice from the combobox ...

Hi Hi Hi-
Ok, I am still trying to get my user form to work. Since the help earlier
just confused me even more I decided to start with a clean workbook and start
from scratch.

How to remove vowels from words? Fpr example, in one row we have
google, excell, macro,... and the result in another row is ggl, xcll,
mcr,... Thanks.