Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default declare type and value on one line?

Jamie,

You can't initialize a variable in its declaration. The closest you can get
is to use the ":" character to put two logical lines of code on one actual
line of text. E.g.,

Dim sexy As Boolean : sexy = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com

"Jamie Martin" wrote in message
...
Can I declare the type and the value of a variable on one line, such as

Dim sexy As Boolean = True

?

Also, can I do a two-condition test, like

If (catsLoveDogs = True) && (dogsLoveCats = False) Then
MsgBox("All is right with the world.")
End If

?




Reply
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
Cant type on line E31. tabatha anderson Excel Worksheet Functions 4 February 11th 10 10:36 PM
Chart Type - Line Column adding a 2nd line [email protected] Charts and Charting in Excel 1 October 24th 06 04:17 PM
The grid line disappear when I type in the cell faylene Excel Discussion (Misc queries) 1 October 8th 06 01:33 AM
Can you type a line over text (opposite of underline)? Matt Excel Discussion (Misc queries) 1 May 26th 06 04:57 PM
Adding a line Chart Type to a stacked-clustered Chart Type Debbie Charts and Charting in Excel 2 January 5th 05 11:25 PM


All times are GMT +1. The time now is 10:13 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"