i have rows that contain two shapes of adresses that i need to fix:
example1 : Rose street 25 4  Blabla ----> Rose street 4/25  Blabla
example2:  Rose street 25/4  Blabla ----> Rose street 4/25  Blabla
thanks

I am trying to create a dialog box that allows the user to selct a date from
a calender. If this is not possible, is there a way to format the box to only
accept a specific date format?

I'm trying to insert the formula shown in CODE 2 below into cells C3:C13.
C3:C13 is a named range that always will be constantly growing, so my
function
InsertFormula() in CODE 1 should handle the range expanding dilema.

I write a sheet with some active-x elements that contains VBA Script and
want to copy a part of it to a new worksheet. I have tried with Method
"Worsheets.Copy" but only the lines and characters were copied, the active-x
objects were not.

basically what I am trying to do is I have to create a form that takes an
entered date and calculates a certain time period ahead.  example is that if
I enter todays date 12/13/2007 I need something that will calculate 10
business days ahead and exclude christmas as its a holiday.  

I have a spreadsheet for recording room usage. Column A has StartTime,
Column B has EndTime and Column C has formula EndTime - Startime.
Each day is split into 6 periods.
If I move (cut & paste) a booking from row 2 to row 4, the formula in

I am looking vor the visual basic code to perform the following action.
I have column "a" with data in every cell, columns "j, k and l 'may have
data in them.
If there is data in j, k or l I want to copy the data from "a" into another

I'm not sure what is going on with my code but it is not calculating
properly.  I am building a quoting system for plastic sign faces.  I have a
UserForm where the user enters Height(feet & inches) and Width(feet & inches)
into textboxes.  My code converts the Height & Width to ...

I am building a product quoting system in VBA for my company that
manufactures outdoor plastic sign faces.  I have a Userform with 6 text
boxes, 1 combobox, command button:
tbxDimHft1 = user enters Height of sign in feet

I've setup a spreed sheet that has formulas from A19:Q1000. You can not see
the formula in less there is data. How can I print out the visable data and
not have Excel want to print out 20 pages with now visable data? e.g. page 1
has data from A1:Q30.

Hello there...
I've written a UDF that allows me to concantenate a range of cell
values with a prefix & suffix value. See below:
Public Function ITEMLIST(ByVal CELL_RANGE As Range, Optional ByVal

I am using VBA in Excel to model some alignment errors in a test fixture.
The output is a multiple series scatter chart of the data. If I calculate
the center and radius of a circle that fits a part of the data (least
squares fit method), how can I draw the circle on a chart?

I want to chek user input on a page (index 1)  of a multipage control as
soon as another  page is selected. I have something like this:
Private Sub mpProcessData_Change()
  If lngLastPage = 1 Then

After I have used this macro
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal
Target As Range, Cancel As Boolean)
I put  data in the activecell with help of a listbox and it worksvery

how do I set  up to click on cell and number pad shows up like ms money