Hey gang,
I have a dialogue box that contains checkboxes of all of the worksheets
names in a file. At the moment the list is in a single column....does anyone
know how I can get the checkbox list to be displayed as TWO columns? The list

Hi!
I have a problem with an application I have made in VBA for Excel and hope
you will be able to help me out.
I have made a small database in Excel with user interface, which is shared

I receive the following information as an attachment to an Email. The
attachment opens in Notepad.
4100,WM7886,255,1404
     4100,WM5589,255,1473

I have written an excel application and now need to document it.
Is there a quick way to document (print) all the code and all the sheet
calculations?
Many Thanks

I want to close the opened but not visible/hidden excelfile "macros.xls"
without saving when I will close the spreadsheet 'main.xls', leaving
"macros.xls' invisible so the next time it wil be opened it will still be
invisible. This hidden spreadsheet will not be the active sheet ...

Does anybody know of some code which would "increase" the letter within a cell?
i.e. if the value of the cell was "A", when you select the cell and run the
macro, it would change the cell value to "B". If you did it again it would
change it to "C", etc... etc...

How do I select the entire row of C after I find and select it?  Thanks
   Set C = .Find("Date", LookIn:=xlValues)
       If C Is Nothing Then
           MsgBox "Not Found!"

When I minimize Excel, my VBA Userforms disappear. I thought the Userform
ThunderdFrame class window  was not a child of Excel, so why does it
disappear?
Any help would be much appreciated.

I got this requirement to export a date string to an Excel file
from VB application. The short date format in each PC's Regioal
Options could be different. When the VB reads the date string
from MSSQL in "MM/dd/yyyy", the application will export it like:

CAN ANYONE HELP????
Please????
I am trying to run a simple macro in a protected workbook.
The workbook is protected adn so too are the worksheets, so the first

i have a single sheet with these 2 events:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Private Sub Worksheet_Change(ByVal Target As Range)
Is there a particular order of execution between these two in excel?

I get this error when the cursor hits the "y = ActiveWorkBook.Name"
line...why??  I'm using Excel 2003.  I've also tried declaring "y" as a
string and variant.
For x = 1 To .FoundFiles.Count

I have a serie of about 10000 (or more) rows of numbers in several columns.
These numbers are from a log in a machine and there are lognumbers for every
miliseconds. Depending of how long one serie is (how many rows) there are
blocks with equal numbers. A long sequens make 32 ...

this error occur:
" Run-time error '-2147319784 (80028018)': Method 'ScrollWorkbookTabs' of
object 'Window' failed
what it this?what will i do?

I have a macro that is invoked when leaving a tab (deactivate), to
clear off some data and do some other functions on that sheet, before
moving to other sheets.
I want to capture the tab that was selected, and then at the end of the