LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
APH APH is offline
external usenet poster
 
Posts: 1
Default Dimension problem

Hi - can someone explain the following please?

if I set up:

dim i , j, k, As Integer

i = 3.7
j = 3.7
k = 3.7

MsgBox i
MsgBox j
MsgBox k

Do the first two MsgBox show 3.7 and only the third as 4.00

In my basic understanding I am assuming that VB will only dim the variable
immediately to the left of As Integer and for the others it waits to set
their type until it comes across them. If this is right, is it bad
programming to declare similar cariable types on a single linbe

thanks

Alex



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
3 dimension chart jack Charts and Charting in Excel 2 December 9th 08 01:43 AM
two dimension look up table Dave Jepson Excel Worksheet Functions 1 October 26th 06 01:03 PM
3 dimension lookup problem barkiny Excel Worksheet Functions 1 March 14th 06 03:05 PM
Matrix Dimension Michelle Excel Worksheet Functions 1 November 24th 05 05:45 PM
Using the sum function in a 3 dimension environment Paul Hargreaves Excel Discussion (Misc queries) 2 February 23rd 05 12:29 AM


All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"