Hello, I have a excel tempate for compiling data. How do I add a Control
button to clear data in unprotected cells only? Can you help? Steve

I want a userforn to search for and get data from multiple cells on the same
row of a closed worksheet.  Then display the data on the userform, in a
number of labels/textboxes, for the user to review (and if requried, enter
on the active worksheet by the click of a command ...

I have identified the relevant threads and have read the pages in the
microsoft support website. Experts, please share with me:

full-proof.

I want to write some VBA to cycle through all worksheets in a workbook and
copies the value 4 cells across from the one that contains "Total" into Row B
of my totals workshets, and also the value in cell D10.
Ideas?

I have a workbook that has data on one sheet that is used to feed a
PivotTable on another sheet. I used a dynamic named range to allow the
PivotTable range to grow/shrink without including blank rows. I also
have macros coded to automatically refresh the PivotTable every time

I have a form to input staff details and l am having trouble verifying the
date format. The staff details exist on 1 Excel sheet in a "database" and
when the form is lauched the existing details are displayed in the form. The
DOB column is formatted as dd/mm/yyyy as is the short ...

this formula is giving me an error. I need the remainder. Am I doing this
wrong?
26 Mod 3

I need a VBA code that will cause the formatting of cells A1:A10 to change to
bold, blue if the value of the cell changes.
There are numerical values coded in cells A1:A10 at present.  If the user
goes into one of those cells and changes the value to a different value, (say

Is it possible to get the full server name in the file path as opposed to
just the drive letter that it refers to?
For example, if I use
ActiveWorkbook.FullName

How can I round a number with increment of 0.5 ? For e.g. 0.1 will be equal
to 0.5, 1.1 will be equal to 1.5, 1.5 will be equal to 2.0 etc.
Thanks.
Gian

I've made a macro which sums up all cells containing a certain color.
Is there a way that I can make a userform to contain a list of all the
colors (with the color itself) instead of the number?
If so how?

I am trying to programmaticaly create a list of hyperlinks on a single
page to particular cells on another sheet in a different workbook. So
far I have been blocked at every turn. I keep getting "Reference is not
valid" errors.

In his blog, Dick Kusleika gives this code for populating a listbox. It
assumes the listbox has been set to to have a column count of 3, and
that there is data in columns A, B and C of Sheet 1. I've checked the
code and it works fine. However, I've tried using the same code to

I need a help for my top problem.  I spend a lot of time but I can't find a
solution for it.  The following is my sample of my code.  I want to sort the
value of str in ascending and the max value of str.  Any help will be
appreciated.

Excel 2002
MDAC 2.8
SQL Server 2000
I'm trying to test a stored prcedure by sending data to it from Excel.