View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Two short questions

hi
1. as a singie or double. single should do (4 bytes)
2. msgbox("this is the first line." & vbnewline & "this is the second."
for more just keep adding more vbnewline

regards
FSt1

"WLMPilot" wrote:

1) How is a variable DIM if it might hold decimal places?

2) Ref Msgbox, how do I show multiple lines within Msgbox? I have two
part-time jobs and I want to display the estimated pay for each for current
payperiod and then a total. I can get it on one line, but I would like to
show each job on separate line and lined up so I can display total amount too.

EXAMPLE: EMS Job1: $100.00
EMS Job2: $235.00
TOTAL: $335.00

Thanks,
Les