I need help converting the following to a date & time that excel will
recognize:  Jan  1 2007  9:00:00:000AM
This data resides in column A and is from a data dump from a read only
database file.  Excel reads it as text.

I am trying to get a name of a sheet from a cell then go to that sheet to put
data into a range of cells.  I get an error on the following code:
Set b = Sheets(a(4)).Range(Cells(33, 3), Cells(33, 8))
'b' is a range and 'a' is an array(1 to 8) as string

I have the following click event tied to CheckBox1 in a userform:
Private Sub CheckBox1_Click()
  If CheckBox1 = True Then
       Selection.SpecialCells(xlCellTypeFormulas, 23).Interior.ColorIndex = 6

one more Q.  how will i go to the last cell in column b and make that the
caption for label1?

office 2007, excel, XP, dell laptop
Of course when I upgraded to office 2007, I have to port my macros.
I am getting a syntax error on this function and do not know why.
Help button is not much use.

how can i hide the workbook and show a userform? i got data that needs to
show in combobox and labels and textboxes that need to enter data to the
workbook.
the code i got i can hide the workbook/application but then the data dont

cant get this figured out...
dont get this to work
Private Sub ComboBox1_DropButtonClick()
ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value

I am using a macro to send e-mails through Excel.  If for example, I want one
word or the whole line to be bold in the e-mail, how would I do this?
Thanks in advance.

i got a few labels on a userform. most of them in a frame.
1) few of them need to show data in sheet1 colum a cell 1 untill empty row
2) other just need to show sheet1 column b cell 25

I have a bit of code that tries to cleat some entries from a sheet if they
are more than 10 days old. Some rows have comments and a small image that
does not delete when you delete a row. I am trying to select it and delete
it. When the select is executed I get the error message.

would it be posible to default the amount enterd in a text box with the
prefix "R" and "." to seperate sents?  we use amounts like R1125.80
and show amounts in lable as that to?
i got this:

I have a macro that grabs info as a query from the internet:
   ThisWorkbook.Sheets("Data").QueryTables("ReportData_1").Refresh
BackgroundQuery:=False
   MsgBox ("Data Successfully Loaded !")

I am not a programmer but can do some basic instructions in excel cells but I
am not able to solve this one. In Excel 2002xp I have a date in one cell and
would like this to display the actual weekday in another cell. Is there a
formula for achieving this?

I have a spreadsheet and a .csv file that do things via a button in a Lotus
Notes database.  The .csv file extracts itself to the hard drive, and is then
imported into the Excel spreadsheet using a Workbook_Open macro. I think I
have a problem with a file or Excel  staying open ...

Hello all, i have a report that has rows added to it and it has both a
columnm that is a range name, so the new cell has to be added to the range
and secondly within that range the cell has it's own name dependant on what
the user puts in.