Afternoon all,
I've been doing some research into reporting errors in custom Excel
functions to the end user today. I've not really come up with any promising
leads so I was hoping someone frequenting this newsgroup might be able to

I have a Worksheet named "Parts", that has a list of parts in it:
  Col. A - Unit Part Numbers
  Col. B - Unit Descriptions
  Col. C - Unit Type (ex.:  sq. ft., ft., each, etc.)

Hi, I would check data table. There are 150 columns about 3600 rows. I
need to check if data field is missing value. If yes, so error message
must be generated. Doesn't anybody know to help me with macro? Thanks
Pavel

Hello all, as i am not a programmer i am battling with the following...
I have a wkb with the main sheet "Hauptseite-1" in this sheet i have a
variable amount of rows with the names of the responsible person in column
"O". I have created a sheet for each name & the sheet is named ...

I'm having difficulting with a program I'm trying to write. Basically,
I want to do a vlookup or a match in vba and if it returns an error, I
want it to highlight a cell and if not, I want it to actually do the
vlookup.

Since I work with a lot of learners with reading/visual e.g. tracking
difficulties, I have customised my interactive workbook with VBA so that the
view changes to "full screen" upon opening it, in order to reduce the "visual
noise" of the ribbon etc (which they can't use due to ...

I am in Europe. I use by default coma as decimal separator.
In a particular situation I need to replace the coma by point. I have this
code:
   Columns("p:p").Select

Hello, I've been playing around with connecting to a database and inserting
information using the following code. (just pasting it in sorry if it looks
messy)
Sub ADOTest()

I am using Excel 2003 SP3. I am validating data upon entry using the OnEntry
and Intersect methods in a VB Applications macro (per article 213373 Rev
3.3). I can get the validate operation to run with no problem on cells where
the user inputs the values (i.e. types in the values) ...

How come this sub only runs through i=1 and i=2, when k is obviously
updated during loop?
Sub Test()
k = 2

Hi, I've inherited a vast add-in and would like to list all UDFs in it.  Does
anyone know of a way to do this?  If possible, I'd like to make a distinction
between visible functions and ones the user doesn't see in the Function
Wizard/Paste Function (i.e. ones that are public as ...

I have received an excel file with vba and it has the code which prevents
the file to display most sheets. Is there any way (user level) other than
deleting or commenting that section of code to display the sheets?
Thank you.

In my workbook, I have 70 worksheets. Worksheet names are in month +
year.
i.e. Jan 05, Feb 05... and so on.
Problem I am having with my worksheets is that they all contain data

Is it possible to draw autoshapes on excel user forms with code on
form load?
Regards
Stefano

I have a UserForm with several text boxes embedded into frames (used only as
a visual aid for grouping the text boxes).
I am using AfterUpdate to validate the user input, eg:
'---------------------------------------