Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Declaring variables
Never mind. Sorted- robbo666
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Declaring variables
Okay..next question :) Is there a VBA equivalent of this VB snippet ======================== VERSION 1.0 CLASS BEGIN MultiUse = -1 'True Persistable = 0 'NotPersistable DataBindingBehavior = 0 'vbNone DataSourceBehavior = 0 'vbNone MTSTransactionMode = 0 'NotAnMTSObject END...- robbo666
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Declaring variables
Effectively, what I'm trying to do is set the format of array elements- robbo666
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Declaring variables
I am set up a number of variables which will then be fed into a dynamic array. Each of the array elements need to be a specific length and I can set the string ones like so Dim stringe1 As String * 15 (setting the length at 15) How do the same for numerics I can format a numberic variable like...- robbo666
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
