Defining variables

The UK's most regular instructor-led training courses.
Training information: excel training course · Excel training courses · VBA training in London

Resolved · Low Priority · Version 2003

Defining variables

Hannah has attended:
Excel VBA course

by - delegate Hannah [1 post] (2008 Apr 29 Tue, 12:25) Reply

what is a string.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	3	book now	£475	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: defining variables

by - trainer Carlos gold contributer [394 posts] (2008 Apr 29 Tue, 14:12) Reply

Hi Hannah

When declaring varalbles one variable type is a String.

A string is a character or a combination of characters that constitute text of any kind and almost any length.

So to declare a string variable you write the following:

Dim UserName As String

Text-based controls such as the TextBox, the ListBox, or the ComboBox controls, have a property called Text. This property is of type String.

So when using such a control, to access the string that it holds you call its Text property. So if you have a text box with the user name you would code

UserName = txtUserName.Text

Hope this helps

Carlos

· Features of Microsoft Excel that assist in Analysis of Financial Data
· Microsoft Excel's Best Kept Secret
· Microsoft Excel Training: Not Just for Newbies Anymore
· Tips to Facilitate Printing of Excel worksheets
· Compare Different MS Excel Training Methods

Please browse our web site to find out more about
excel training course and other Microsoft training courses.

Excel tip:

Get to the end of the used range

What’s the quickest way to get to the bottom right of the used range in your spreadsheet? The two-handed method is Ctrl+End (hold down Ctrl and press End). The one-handed method is End Home (press and release End, and then press and release Home).

The last cell so selected may appear to be empty. However, there is a cell in that row that has an entry or a format and there is a cell in that column that has an entry or format.

View all Excel hints and tips