I have a userform calendar that I want to input a date with. What I
want is:
1. The form to remain visible while I select another cell to input to.
2. The input cell must be in the range "Dates"

I would like help on how to view show columns when working on a worksheet,
but hide them when I print my worksheet.  Can anyone help please?
Thanks!

I'm trying to get data to fit an excel row.  I tried to use the autofit
method, but it si not working.  This is my code:
           CoverWs.Range("a1").WrapText = True
           CoverWs.Range("a1").EntireRow.AutoFit()

I need some help using for each / next, as I am not very familiar with
how to use it.  I have a worksheet with many combo boxes.  I want to
ensure that all of these drop downs have an answer before being emailed
back to me for review.  I was thinking something along these lines...

I have an small program with a bug in the second pass to print a spread
sheet, it does the fisrt time without no problems, but the second time,
doesn't work anymore.
NEED HELP..

I need to go to the next iteration of my loop from within my IF
statement. How is this done? I can't belive I can't find such a simple
thing on my own...
For i = 1 To lastrow

Ques 1: I want that when i send the excel file to somebody then he
should see only vb screen not my excel data sheet.. so it should open
with vb page as its front page. How can it be done?
Ques2: When we are accessing data from an excel file to vb's textbox

How do I change the tab name for a worksheet in VBE?

something like:
Function Number2Row(Number As Long) As String
' 1 bis 256
Dim OrgValue As Long

I have several textboxes that I'm going to need to limit the text in to a
specific number of rows... not all the same number of rows... dependent upon
which box it is.
I have the limiting code working reasonably well for a give box, but would

Please help me on how to hide specific cells when printing.
Thanks!

I have a macro that is opening a number of *.txt files.  I need the macro to
open the files in the order in which they were created (by date and time).  
By default it looks as though Excel is opening them by extension/name.  
Anybody know how to specify this?

Group,
Is there a function in VBA that will convert hex into ascii.
Example assume I have 0x39 and I want it to convert it to ascii, or 9.
Same goes for the alpha characters as well A thru Z both lower case and

Can someone tell me please how I can do the following, I am trying to
conditionally format a range of cells which sum from others.
I have used the following:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)

I am working on revamping an old timesheet, which currently has the
entire year on one sheet.  Typically, we have to re-enter the dates for
each new year, which can be a very messy proposition, especially if the
time coordinator rearranges the size of the sheet.