I would like the user to be able to click on a cell in a sheet to tell the
program where something is.
1) Click a command button to start the program
2) Ask the user where the first sheet to work with is

I have the following data format:
ItemName       ItemNum
and I want to display only ItemName in my dropdown control and use ItemNum
as value. What is the delimiter between ItemName and ItemNum?

I have a textbox on a worksheet and a macro is attached to the textbox when
there is a change. However, the textbox1_update event is called when the
first keystroke is hit. So if I want to enter 45, it only recognizes 4 and
not 45. Am I calling the right event? I just want to be ...

Hello from Steve Dee
I have in Cell J2 the Value SWANSON DEPOT
If I put in another cell =PROPER(J2) it will change it to Swanson Depot.
My question please is it possible to do an event Code please.

I am using the below code to export the last row in the 'Site Reading Log' to
a new workbook on the desktop, named 'Copreco Daily Reading Submission'.  It
works great, it overwrites the last file exported to the desktop, of the same
name.

The following code saves the spreadsheet in question, overwriting any
existing with the same name, that is found on the Desktop.
Question:
How can i change this code such that it prompts me to Save As, rather than

I want to have an excel VBA macro that accesses my MS Exchange email inbox,
finds certain emails based on sender/subject, moves the emails to another
folder, and detaches and processes any attached files.
Due to security with Outlook (get a warning message "...external ...

I had a legacy component that was created in vb6.0 and built an excel 2003
workbook by by xml document with that comply the excel 2003 schma.
I upgraded it with th VS2005 wizard to vb.net(so It uses the interop of
DomDocument and not system.xml classes)

I get the error, "Unable to get VLookup property of the WorksheetFunction
class" for the following sub:
Sub ShowEmpolymentFollowup()
   PasswordOff

On a form there are 3 rows consisting of 5 controls each row. After
inputting, these contents of the controls should also be aligned up neatly in
a merged range cell in the following format:
Row1Field1   Row1Field2   Row1Field3   Row1Field4   Row1Field5    

Q1/
a/    Describe 5 different data types used in Visual BASIC for
Applications. Each description should contain a definition of the data
type and an example of the type of data it can hold.

I need something that is to the purpose of:
if the cell is highlighted, copy the row and paste it here.
What is the code for testing whether a cell or row is highlighted?
Thanks.

I have a form on a single worksheet. I would like to run a macro
that replicates the sheet for each day of a month and uses each
day's date as a sheet tab label (format: Monday 05/21/07) and puts
that date on the sheet.

I read and manged to get all the COM Demos working from the COM Automation
Feature Developer's Guide
<http://www.oracle.com/pls/db102/to_toc?pathname=win.102%2Fb14310%2Ftoc.htm&remar
k=portal+%28Windows%29>.
I have changed the Excel Demo to match what I want to use in my Database.

I have a sheet that is like this:
A               B              C
content       0              Yes
content