I don't understand why this is happening. I have a form with a listbox and
four textboxex. when an value is selected in the listbox, the 4 textboxes
need to show data (vehicle information) from the same row as the selected
value.

I get error 1004; "Unable to get the VLookup property of the
WorksheetFunction class" on the following line of code:
-myHoliday = Application.WorksheetFunction.VLookup(myDate,
Worksheets("Supporting Sheet").Range("PayPeriod"), 3)-

Hello Group,
I have a spreadsheet in which I am using the Monotype Sorts font to
represent a check mark. This has worked great for all of my users up
until now. I have a new user and when he views the sheet the check mark

I have tryed to print barcodes to a barcode printer using the special
commands like "^LM30,21" Zebra prinrer. If I copy a textfile with the correct
code as a DOS command Copy Myfile.txt LPT1,  I get something like a formfeed.
I only want one label with the barsode. How do I ...

Hi, I have an excel spreadsheet which I'm using as a template. It has a
macro which imports data from elsewhere and reformats it.  When the
macro is finished, I want the user to use save as to save the worksheet
under a different permanent name.

While Googling for methods to prevent students from cheating with
Excel by copying each others files, I came across this post:

Through Insert | Name | Define, I can create a name (for example “MyRatio”)
to hold the value 2.53. In VBA, how can I create a function to hold this
value?
I know nothing about creating Custom VBA Function and is trying to learn

Example If cell A1= STEPHEN R WILSON
I would like A1=STEPHEN WILSON

In VBA code behind a button, how can I determine the
active cell row and column address?
TIA,
Ron

I want to get the date the file I'm working on was last saved and place that
value into a cell.
I don't see a built in function to do this, any help is appreciated.
Hal

I know the method to count the option buttons(From form toolbar) on one
worksheet as follow:
Worksheets("Sheet 1").OptionButtons.Count
Now, I want to count option buttons on specific range on worksheet,

Why can't i use this:
Dim num, num2, num3 as single ?
Shall i use this:
Dim num as single, num2 as single, num3 as single??????????

I have a popup calandar that all of a sudden doesn't show any dates. I can
click on a blank date  block (knowing what date it is by its location on the
calandar) and it will put the correct date in the selected cell
I have not done any revisions to the workbook.

I have copied a webpage that has buttons.  I'm trying to get the text that is
shown in the buttons.  I have tried shapes("Control Button Name").Name ,
text, caption, etc. I have used the script on
http://www.mvps.org/dmcritchie/excel/shapes.htm

I want to sum the contents of 2 visible columns, but hide the sum and
test it's value for a macro. It doesn't work when I hide the sum
column, it's giving false results. Is there a workaround for this, or
just a better way?