String (fix len).length of of any ASCII characters, of a pre-defined length. String.10 bytes + 1 byte per char.$.Series of any ASCII characters. Object.4 instance of a class or object reference. Integer.2 bytes.%.Whole numbers ranging from -32,768 through 32,767. īyte.1 whole number ranging from 0 through 255 that can be represented as a binary value.īoolean.2 or False value The intervening dots are my attempt to enhance readability for the fields on this html page. Those abbreviation characters have been around for awhile, here is a general overview of variable types, their abbreviation characters, and their description.

The % is an abbreviation for saying 'as Integer'. The $ is an abbreviation for saying 'as String'. I really appreciate the quick response and the help. Now that I have clarified things a bit, can you help me a bit further with the code? Perhaps the list of account names can go in an array or something? I should point out that the spreadsheet contains two other drop-down lists and my plan was to mimic the code for those. Note: There is a possibility that I could be changing/adding items to the list in the future but I can worry about that later. In the end I will want is a series of uniquely worded list items that are quite different from one another.

It appears as though the code you provided concantenates 'ListItem' and 'i', which is not quite what I had in mind. 'Questrade TFSA', 'TD Waterhouse Spousal SDRSP', etc. These were substitutes for account names that I am using in the spreadsheet, e.g. In my code I used ListItem1, ListItem2 and so on.

Second, I may have inadvertently misconstrued the situation.

I have two questions regarding the code so that I understand it and possibly use it again in the future.įirst, could you tell me what the' $, i%' in the Dim statement signify/does? I am in the throes of creating my first code in VBA, which of course means that I am on a bit of a learning curve.

Add a drop down list in excel