I am attempting to create a user form with combo boxes or a drop dow
list.
How do  enter the Data to be dropped down from this. I know how t
create a list using Validation however this does not help with use

Is there any VBA way that when a user enters an invalid name into a cell with
validation that they can be prompted to add the new name to the list?

1. how to achieve to define a name of the xls file if there
are spaces 'like "this excel sheet.xls". And this seems to be refused by
Excel. How to solve this ?
ex:

I need to process some data that looks like this:
02.01.01.01    PSE Staff
02.01.01.01    PSE Staff
02.01.01.01    PSE Staff

Hi this is a 2 part question. Again - im new to this so please be
patient. :)
1 - Would anyone be able to explain to me how to get excel to ignore
the "$" symbol if it is entered in a text box? The situation is:

I have a VBA function in a cell of one worksheet and want to use the value in
a cell of another worksheet.  I haven't been able to figure out how to do
that.
Bob

My Immediate window does not show up at the bottom of my page when I click
onto View/Immediate Window.  It now shows up as a full sheet.  I went to
Options and it is clicked off as dockable.  Don't know what I did.  How do I
reset it so that it shows up below my code window.

I have a Visual Basic command button on an Excel worksheet. When the command
button is clicked I need the code to make use of the column number of the
active cell. How is this found?

ok here is what i have.
      A     B     C      D         E
1      V     W     X      Y
2    1.95  1.55   1.75   2.05   #Display

All of my spreadsheets have similar Hide and Unhide macros. These handle
all the sheet hiding and protection. I gave the macros the shortcuts of
Ctrl-i and Ctrl-u. But if more than one spreadsheet is open, the shortcuts
don't work. Why is this? This annoys my users, as they all know ...

       "ActiveCell.Offset(6, 96).Copy" This gets me to where I want to copy
a cell
but    "ActiveCell.Offset(-6, -96).Select" doesn't take me back to the
previous cell.

Here's what I have:
The user wants to find a record. He clicks a button  to request this,
and enters a PO number. A sub in a standard module is executed that
performs a Find. Then another UserForm comes up showing the record. One

I am putting a number in cell A1
the number is an order number that was generated
however when I put in the number, the last few digits are showing a
0's.

hihi~~
newbie here, i been looking over the place for an excel code and
decided to use this functio
http://www.excelforum.com/showthread.php?t=335941&highlight=edit+data+form

If I have an excel spreadsheet, (on a Windows Millennium computer) which
has an InternetExplorer object embedded into a userform, and I move this
to a WinXP computer (where the version of IE will be slightly
different), am I likely to run into any problems, i.e. will I have to