Here is the cmdOK_Click event of my user form.  What I need it to do is
based on the time input in the pckApptTime on my form to have it offset
to a different range of cells (ie:  if time is 7:15, then the active
cell offset is range A1, looping for a blank cell.  If the time is 8 ...

Is this syntax correct:    
=ROUNDUP((I35+I38),2)
(need ROUNDUP sum.)

Thanks in advance for any help you can give me.
I have a rather annoying problem with excel. After I import text data
into Excel (whether via a macro, or doing it manually from the menu), I
can no longer open a new excel workbook by double-clicking it from the

Anyone know the VBA code for poping out an error message box?
I am creating a worksheet where the user can enter values to certain
cells before clicking the "run" command button, and when the button is
clicked, i want it to check wheather the cells that require input are

Im creating a workbook, and was thinking of using a macro. I've decided
otherwise, and can not get rid of the prompt that reads:
"the workbook you are opening contains macros" with the options to
"enable macros","do not open" or "disable macros.

Right now I have a number of IF statements as part of my work sheet. I use it
to look up the applicable currency for the row and then do the conversion. I
think it is too much calculating for EXCEL 2007 to do.
Any ideas? Thoughts? Comments?

Does any one know how to turn an image into a command button? or a
toggle button? The standard command button is retangular, and i want to
make it into a different shape, i tried editing its properties and
inserted an image , but the image is contain inside the rectanglar

I have a created a worksheet and within it I want to change a text cell
value to a corresponding number value. There are 22 different 'text'
scenarios with different number values. For example if a cell contains
the entry "P1" then the value given would be 1, or if the entry was

I inherited an excel file.  When I open it, I receive a security warning for
a macro to enable or disable.  I do not want any macros associated with this
file.  Therefore, I  did Tools, Macro, Macro and looked for the macro name -
there is not names listed to delete.

I have two lists :A with 3 Columns: Name, First Name, E-mail
and list B with 7 Columns : Name, First Name, Street, City, Region, Post
Code and Counrty
The names of list A are included in the list B. How can I have the names and

I have created a drop down list by using data validation.  The issue is I
need to give people the ability to see the description of the item but have
the item number populate that cell (which is to be used for other lookups and
tables).  I have done this before with a description ...

Having a problem trying to use MATCH, INDEX and SUMPRODUCT to produce a list
from some data.
In row 1, I have Business Process Numbers (BP's) in this format:
     1.01 44.01 46.02 46.03 46.06

give me complete formula

I have written an Excel spreadsheet which I share with others, who may
then share with others....  I would like to keep my coding in the VBA
Project private.
Doing some research on the web, I found that password protecting the

I am creating a spreadsheet that I need to print on 11x17 paper. My printer
does not support 11x17 but I can send it to someone that does. How can I
format my spreadsheet to use 11x17 so I can see all the cells etc.
My guess is I need to install a print driver that supports 11x17 ...