I have written a fair amount of code in Excel 95 and am just considering what
and how to convert it to Excel 2003. I am not even sure where to start.
Suggestions?
--
ksn

Most of Excel 95 VB code will run in later versions as is. So run it and
wait for bugs and errors, if any occur, and then fix them.

--
Jim
"ksn" wrote in message
...
|I have written a fair amount of code in Excel 95 and am just considering
what
| and how to convert it to Excel 2003. I am not even sure where to start.
| Suggestions?
| --
| ksn

True. I have not experienced any bugs, however I am still interested in
making at least one change.

I am particularly interested in converting a DialogSheet to a UserForm. I
have found utilities for converting the sheet to a form and they work fine.
Howver, the code would now be different for looking to see if certain boxes
are checked. This particular code is used to print out a variety of views in
the spreadsheet for documentation purposes. For instance:

' Total Project Cost
If DialogSheets("PrintDialog").CheckBoxes("Check Box 17").Value =
xlOn Then
CHECK = 1
SUBCON = 0
LABOR = "TOTAL_COSTS"
FEE_DETERMINATION = "NULL"
PHASE_SUMMARY = "NULL"
EXPENSES = "NULL"
FIXED_FEE = "NULL"
SALARY_ESCALATION = "NULL"
LABOR_RATES = "NULL"
COLUMNS1 = "Print_Columns_Total"
TITLES1 = "Print_Titles1_Total"

SheetNameVar = "V4"
CompanyName = "D4"

Application.Goto Reference:=LABOR
Application.Run Macro:="Macros.Page_Setup_Master"
Application.Run Macro:="Macros.Print_Comp_Team"
SUBCON = 0
End If

What should the code be changed to so that it looks at the user form?

The other related question is how do I determine whether to place the code
in a module or in ThisWorkbook?


--
ksn


"Jim Rech" wrote:

Most of Excel 95 VB code will run in later versions as is. So run it and
wait for bugs and errors, if any occur, and then fix them.

--
Jim
"ksn" wrote in message
...
|I have written a fair amount of code in Excel 95 and am just considering
what
| and how to convert it to Excel 2003. I am not even sure where to start.
| Suggestions?
| --
| ksn